Subject | Timestamp and CURRENT_TIMESTAMP resolution |
---|---|
Author | Andrew Guts |
Post date | 2002-06-18T11:19:04Z |
Hello all.
Does anybody know why CURRENT_TIMESTAMP returns values rounded to
seconds? How to get microseconds also?
Even I specify 'select cast((CURRENT_TIMESTAMP+0.5/86400) as
varchar(32)) from table1' i have results look like *.0000 .
Thanks ahead.
Andrew
Does anybody know why CURRENT_TIMESTAMP returns values rounded to
seconds? How to get microseconds also?
Even I specify 'select cast((CURRENT_TIMESTAMP+0.5/86400) as
varchar(32)) from table1' i have results look like *.0000 .
Thanks ahead.
Andrew