954,574 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Regarding time

In mysql database for date filed i'm using datatype as Timestamp in that field date part is updated as today's date but when comes to time it is updating as 09:00:00 like this instead of 15:00:00 and i'm using wamp.can anyone solve this problem.

srilakshmitr7
Light Poster
32 posts since Aug 2008
Reputation Points: 16
Solved Threads: 2
 

i am not sure but i think the time the database uses is the system time of your computer... check if your time is adjusted in your local time in your country. If not, you can alternatively check the time using your language either PHP and compare it to the time from the database.. tell me the result afterwards.

it2051229
Junior Poster in Training
82 posts since May 2007
Reputation Points: 7
Solved Threads: 1
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You