|Subject||Re:cast TIMESTAMP as integer|
no, it's work perfectly, and return me an integer :)
--- In email@example.com, "Alan McDonald" <alan@...> wrote:
> > You can't cast directly, however you can do the following:
> > select cast(current_timestamp - cast('12/30/1899' as timestamp) as
> > integer)
> > from rdb$database
> > Subtracting 12/30/1899 will subtract 0 and not alter the date/time you
> > already have, however it will force the result to be returned as
> > numeric(18,9) which can then be cast as int.
> But surely this will give the date only (when you cast).
> What does the op want? the time? or the date?