dates and times

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
m3rajk
DevNet Resident
Posts: 1191
Joined: Mon Jun 02, 2003 3:37 pm

dates and times

Post by m3rajk »

aside from having php call the date in utc and sendnign it it, or using a server in gmt, is there any way to get sql to do gmt/utc? i notice NOW(); brings up the current time in my timezone
m3rajk
DevNet Resident
Posts: 1191
Joined: Mon Jun 02, 2003 3:37 pm

Post by m3rajk »

since no one seems to be able to answer....
The following information was sent by you to MySQL AB:

Name: Josh

Email address: archimedes5739@hotmail.com

Company: N/A

Position/Title: N/A

Type of interest: for personal use

State or province: MA

Country: US

Support contract: no

Enter Your Questions, Comments, Feedback or Your Message here:

I was looking through the online manual for a way to insert a UTC/GMT
date since it strikes me as being something that would allow a
company/website to modify things for where the person looking at the
page is from. I did not see any way to get the UTC/GMT
datetime/timestamp (i'd be interested in using it in conjuction with
both data types).

I have mysql version 3.23.56. If i merely missed seeing the function,
could you please let me know what it is and if it's available in
3.23.56? If there isn't one, then consider this a suggestion to add a
UTCNOW() that is like NOW() only it gives the UTC/GMT value
reguardless of a person's timezone.

hopefully helping to improve your product,
Josh
was sent to mysql.com
Post Reply