By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Round Time to Nearest Second

100+
P: 121
I have a coupe of queries where I use the Time() function. Later I need to match these records to each other. But I have a certain situation where the queries are run on different records at barely different time (a few seconds apart). So the records end up not matching to each other. So I would like the function to round to the nearest minute so that they will still match. How do I do this?

I have tried format(tim(), "HHNN"). but I get no value that way.

any ideas on how to fix this?
May 6 '07 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
It would probably help if you replaced tim() with time() ;0)>
May 6 '07 #2

JConsulting
Expert 100+
P: 603
format(time(), "hh:nn")
May 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.