Subject Re: [firebird-support] Date to seconds
Author Don Gollahon
Just tried this, it works:

select (cast(cast(CALL_DATE as timestamp)-
cast('1/1/1970' as timestamp) as numeric(15,2))
* 86400.0) as DateInSeconds
from mytable

""Martin"" <moirae@...> wrote in message
Could anyone help me please? I need to convert date to count of
seconds from Jan 1 1970 inside SP. I tried to make it with CAST(),
but I wasn't successful. What should be the right syntax or functions?


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to