I think if you read Technet Forums thread again you will see that Laurent provided workaround for versions prior to 9.2.0.5.
Code:CURRENT_TIMESTAMP - TRUNC (CAST (CURRENT_TIMESTAMP AS DATE))
|
Results 1 to 10 of 21
Thread: using TRUNC in timestampsThreaded View
|
Click Here to Expand Forum to Full Width |