Subject | Firebird 1.5 Timestamp milliseconds |
---|---|
Author | ugog |
Post date | 2004-06-17T07:19:25Z |
Hi,
I have a timestamp field filled with the CURRENT_TIMESTAMP function,
but when I convert it to a varchar I always see something
like "16/06/2004 09:14.45.0000", where the milliseconds part is
always "0000". I convert it doing Cast(DocDate as varchar(24))
I think there are two possibilities:
- CURRENT_TIMESTAMP correctly fill the field, but "Cast" doesn't work
properly so it forgets my milliseconds.
- CURRENT_TIMESTAMP doesn't fill the field with milliseconds.
Thanks in advance for the help you could give me.
Ugo Galbiati.
I have a timestamp field filled with the CURRENT_TIMESTAMP function,
but when I convert it to a varchar I always see something
like "16/06/2004 09:14.45.0000", where the milliseconds part is
always "0000". I convert it doing Cast(DocDate as varchar(24))
I think there are two possibilities:
- CURRENT_TIMESTAMP correctly fill the field, but "Cast" doesn't work
properly so it forgets my milliseconds.
- CURRENT_TIMESTAMP doesn't fill the field with milliseconds.
Thanks in advance for the help you could give me.
Ugo Galbiati.