Rounding the current time to next hour PLEASE HELP

[THEJOESTER]

Hi, this database that I am making is for a train station that has runs on the hour. What I want is the code to make the current time (Time()) to be rounded to the next hour. Example: the time is 9:04, I need it to be rounded to 10:00. I need this so I can use it in queries so I dont have to keep going into the queries and changing the time value. Please Help. Much Appreciated.

 

[baltman]

Are you using VFP (Visual FoxPro) as a front end?

 

[TamarGranor]

Just want to point out that the stuff you have in the HAVING clause really belongs in the WHERE clause. Moving it should speed up your query considerably.

Tamar

 

[THEJOESTER]

I have solved the problem, thanks

 

[NasibKalsi]

The best solution, IMO, is Olaf's...Short and effective.

Imaginecorp

I agree.

Nasib

 

[NasibKalsi]

Another revised and shorter version

? transform(val(time())+1%24,"@L 99:00:00")

Nasib