Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Limiting Precision of CURRENT_TIME |
Tue, Jun 12 2007 5:50 PM | Permanent Link |
Gordon Turner | Is there a way to use CURRENT_TIME to set a Time field value, but limit
it to Hours and Minutes, or Hours, Minutes & Seconds (01:15:00 PM or 01:15:03 PM instead of 01:15:03.0843 PM)? I'm using the Time field as a part of my primary key, and trying to re-select the record after the time to (at least) 4 decimal places is recorded makes it really hard (if not impossible). -- Gordon Turner Mycroft Computing http://www.mycroftcomputing.com |
Tue, Jun 12 2007 7:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Gordon,
<< Is there a way to use CURRENT_TIME to set a Time field value, but limit it to Hours and Minutes, or Hours, Minutes & Seconds (01:15:00 PM or 01:15:03 PM instead of 01:15:03.0843 PM)? I'm using the Time field as a part of my primary key, and trying to re-select the record after the time to (at least) 4 decimal places is recorded makes it really hard (if not impossible). >> You can do so, but it is a little convoluted. You have to EXTRACT each field from the time and then cast the whole lot back into a TIME value from a string that is built from the fields. I'll see if I can get a parameter to the function for specifying the precision in the next build. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |