Getting current date/time Mac OS total seconds

jda jda at his.com
Fri Dec 21 13:25:24 CST 2007


>
>
>-- How much seconds passed since 01.01.1900
>SELECT datediff( '1900-01-01 00:00:00', now(), 'second' )
>

Hi Ivan,

A followup. I'm storing the total seconds in my db in a varChar 
field. I don't see a way to convert a string to a number (a double in 
this case). Can Valentina SQL do this?

Thanks,

Jon


More information about the Valentina mailing list