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 6 Light Poster
it2051229 -3 Junior Poster in Training
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.