Joanne Pham wrote: > Hi P > Sorry for the confusion! > Current my hourAppAcclTable is store the following > 1, 1198990800 > 2, 1198998000 > which is 2007-12-29 21:00:00 and 2007-12-29 23:00:00 if I used the datetime > function to show the time format. > What I want is to store this time stamp in different table but truncate all > the hour fraction, dayAppAcclTable > 1, 1198915200 > 2, 1198915200 > which is 2007-12-29 00:00:00 which GUI run the datetime function > > Thanks a lot, > Joanne
If you're dealing with dates or times I always store the full unixtime (like you are) and then use the functions date, time, and datetime to get the parts you need. That way you have the most functionality as well as requiring the least amount of storage space (4 bytes for a unixtime). -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
