| Subject | Re: [firebird-support] timestamp on FB 1.5 |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-02-12T12:02:56Z |
At 10:00 PM 12/02/2009, you wrote:
Try the same statement in isql and you should get the full 'hh:mm:ss.dddd' output. Most GUI things can't do a ten-thousandth-of-a-second mask, but the subseconds are always zero for both 'now' and current_timestamp in Fb 1.5 anyway. (You need the UDF function GetExactTimestamp() to get the subseconds prior to Fb 2.)
./heLen
>Dear ALL,You're probably using a GUI interface with its own time mask idiom.
>
>
>How to fill my timestamp field so it should be like this '12.02.2009 09:16'.
>I've tried this syntax
>
>*set table1.datecome = current_timestamp*
>
>and either
>
>*set table1.datecome = cast('now' as timestamp)*,
>
>but it's still doesn't work correctly.
>The result still '12.02.2009 00:00'.
>
>Please help. (PS : my FB is 1.5 and Dialect3)
Try the same statement in isql and you should get the full 'hh:mm:ss.dddd' output. Most GUI things can't do a ten-thousandth-of-a-second mask, but the subseconds are always zero for both 'now' and current_timestamp in Fb 1.5 anyway. (You need the UDF function GetExactTimestamp() to get the subseconds prior to Fb 2.)
./heLen