dates and times
Posted: Mon Aug 04, 2003 1:56 pm
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
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
was sent to mysql.comThe 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