Regarding time

Reply

Join Date: Aug 2008
Posts: 31
Reputation: srilakshmitr7 is an unknown quantity at this point 
Solved Threads: 2
srilakshmitr7's Avatar
srilakshmitr7 srilakshmitr7 is offline Offline
Light Poster

Regarding time

 
0
  #1
Jun 20th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: May 2007
Posts: 81
Reputation: it2051229 is an unknown quantity at this point 
Solved Threads: 1
it2051229 it2051229 is offline Offline
Junior Poster in Training

Re: Regarding time

 
0
  #2
Jun 20th, 2009
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



Tag cloud for PHP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC