Petty_Crim Posted September 26, 2007 Share Posted September 26, 2007 Basically I want to know how I can get todays today as in say 25/9/2007 and store the day (27) in a day field in my db and the month in another field in my db and also the time hours and minutes in another field in my db. I'm also confused as to what way is the best way ie should I use timestamps or just dates? Quote Link to comment https://forums.phpfreaks.com/topic/70758-dividing-a-date-up-and-saving-it-into-different-fields-in-the-db/ Share on other sites More sharing options...
BlueSkyIS Posted September 26, 2007 Share Posted September 26, 2007 why? Quote Link to comment https://forums.phpfreaks.com/topic/70758-dividing-a-date-up-and-saving-it-into-different-fields-in-the-db/#findComment-355752 Share on other sites More sharing options...
Petty_Crim Posted September 26, 2007 Author Share Posted September 26, 2007 why? The reason is because i'm outputting it in a different way. I got a function that takes a number and changes it into text ie 9 = September. Thats why i need the days and months separate. Quote Link to comment https://forums.phpfreaks.com/topic/70758-dividing-a-date-up-and-saving-it-into-different-fields-in-the-db/#findComment-355793 Share on other sites More sharing options...
Petty_Crim Posted September 26, 2007 Author Share Posted September 26, 2007 Anyone know? Quote Link to comment https://forums.phpfreaks.com/topic/70758-dividing-a-date-up-and-saving-it-into-different-fields-in-the-db/#findComment-355841 Share on other sites More sharing options...
rarebit Posted September 26, 2007 Share Posted September 26, 2007 I always use unix time, cos it's in seconds and therefore very easy to compare and do math with. I only format it when outputting to humans... Use the php function time() and date()... Then you know what the time will be before putting to db, then it can be used for a few things, all with EXACTLY the same timestamp! http://uk3.php.net/manual/en/function.time.php http://uk3.php.net/manual/en/function.date.php Quote Link to comment https://forums.phpfreaks.com/topic/70758-dividing-a-date-up-and-saving-it-into-different-fields-in-the-db/#findComment-355847 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.