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
news:<20030709150342Z1593315-5592+228139@...>...
Hi.
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?
Thanks.

Martin






To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/