NOW()? to change by -3 hours

Databases
1

I use the NOW() to get the current timestamp. Its three hours fast and how can i change it to subtract 3 hours before it gets put into my table?

2

You posted this in the Business forum.

What language are you working in?

3

oh dang, I tried to do it in the database section, sorry

4

I moved it for you. We still need to know what language you are using though (and your code would help).

5

Try this

NOW()-INTERVAL 3 HOUR

I’m assuming MySQL.

6

thanks ryan

yes, the language is mysql

7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.