Bryan Cantwell Get date from unix_timestamp only up to the hour
Feb 24, 2011; 10:41
Bryan Cantwell
Get date from unix_timestamp only up to the hour
How would I go about modifying a unix timestamp to actually represent the 'top of the hour' that it represents? For instance: 1296158500 = 1/27/2011 2:01:40 PM That is in the 2:00 pm hour, how can I find that out and modify it to 1296158400 which = 1/27/2011 2:00:00 PM?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Feb 24
Nathan Sullivan Re: Get date from unix_timestamp only up to the hour
Feb 24, 2011; 10:56
Nathan Sullivan
Re: Get date from unix_timestamp only up to the hour
Feb 24
Michael Dykman Re: Get date from unix_timestamp only up to the hour
Feb 24, 2011; 11:55
Michael Dykman
Re: Get date from unix_timestamp only up to the hour
Feb 24
Bryan Cantwell Re: Get date from unix_timestamp only up to the hour
Feb 24, 2011; 11:07
Bryan Cantwell
Re: Get date from unix_timestamp only up to the hour
Feb 24
=?ISO-8859-1?Q?Pint=E9r_Tibor?= Re: Get date from unix_timestamp only up to the hour
Feb 24, 2011; 18:06
=?ISO-8859-1?Q?Pint=E9r_Tibor?=
Re: Get date from unix_timestamp only up to the hour
Feb 24
=?ISO-8859-1?Q?Pint=E9r_Tibor?= Re: Get date from unix_timestamp only up to the hour
Feb 24, 2011; 18:09
=?ISO-8859-1?Q?Pint=E9r_Tibor?=
Re: Get date from unix_timestamp only up to the hour
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!