On Wed, Jan 07, 2009 at 09:49:41AM -0800, David Svenson wrote:

Hi there...

I've been trying to export the mtime. str_to_date function to the sql interface by calling the following script from the sql client:

create function str_to_date(s string, format string) returns date external name mtime."str_to_date";

After the function was created, I am trying to use it in the following way:

select str_to_date('6 Dec 2001 12:33:45', '%d %b %Y %H:%M:%S');

But, I always get an error:

"mtime.str_to_date:strptime support missing"

You need strptime, which isn't always available. For example its missing on windows. On unix you could check your MonetDB5 configure logs why its not found. Niels

Am I supposed to load some extra module into the server that is not loaded into the monet server on startup?

Thanks for everthing… -- View this message in context: http://www.nabble.com/Function-errors-tp21336686p21336686.html Sent from the monetdb-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl