| Subject | Re: [firebird-support] cast TIMESTAMP as integer |
|---|---|
| Author | Anderson Farias |
| Post date | 2009-11-25T13:49:39Z |
Hi,
|how to cast a timestamp field to Integer ? i can eventually truncate the
time of the TimeStamp.
you can cast (timestamp_field as date) and than you can subtract from some
"arbitrary" base date -- like the "zero" date that, *AFAIR* is 12/30/1899
but you need to confirm that.
Regards,
Anderson
|how to cast a timestamp field to Integer ? i can eventually truncate the
time of the TimeStamp.
you can cast (timestamp_field as date) and than you can subtract from some
"arbitrary" base date -- like the "zero" date that, *AFAIR* is 12/30/1899
but you need to confirm that.
Regards,
Anderson