gc40 Posted December 1, 2007 Share Posted December 1, 2007 I have a database field called `DATE` which has data type date. The purpose of `DATE` as you guessed is to store a date. 2007-11-31 I want to write a script to update a news article posting date. The only way to do this is to break DATE into three separate sections, $year, $month and $day How do I go about doing this? Please keep in mind, the date is already stored in the database, it does not need to be today's date. It can be any date! Lets work with 2007-11-31 as an example. Link to comment https://forums.phpfreaks.com/topic/79678-displaying-date-from-database/ Share on other sites More sharing options...
Dane Posted December 1, 2007 Share Posted December 1, 2007 $dateformat = strtotime("$daterow"); date("Y", $dateformat); // for year date("m", $dateformat); // for month date("d", $dateformat); // for day is how i did it. Link to comment https://forums.phpfreaks.com/topic/79678-displaying-date-from-database/#findComment-403510 Share on other sites More sharing options...
gc40 Posted December 1, 2007 Author Share Posted December 1, 2007 How would I declare YEAR as a variable with your example? $year = date("Y", $dateformat); ??? Link to comment https://forums.phpfreaks.com/topic/79678-displaying-date-from-database/#findComment-403511 Share on other sites More sharing options...
Dane Posted December 1, 2007 Share Posted December 1, 2007 like that i believe Link to comment https://forums.phpfreaks.com/topic/79678-displaying-date-from-database/#findComment-403514 Share on other sites More sharing options...
gc40 Posted December 1, 2007 Author Share Posted December 1, 2007 Not working!! I think there is something wrong... How do I link the field `DATE` to your code? It ins't right. Link to comment https://forums.phpfreaks.com/topic/79678-displaying-date-from-database/#findComment-403517 Share on other sites More sharing options...
Dane Posted December 1, 2007 Share Posted December 1, 2007 You need to Select it from the database. $daterow = $row['date_field']; Link to comment https://forums.phpfreaks.com/topic/79678-displaying-date-from-database/#findComment-403519 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.