antilectual Posted November 14, 2003 Share Posted November 14, 2003 on my news manager i have been using CURDATE() to insert the date on which a news item was posted, but now i have changed the column from date to datetime (YYYY-MM-DD HH:MM:ss) and curdate() will not enter the time. is there something else i can use? what does timestamp() do? this is my query at the moment: "INSERT INTO News SET NewsTitle=\'$title\', NewsDate=CURDATE(), UserID=$user_id, NewsText=\'$text\'"; any ideas? cheers, Antilectual Link to comment https://forums.phpfreaks.com/topic/1367-inserting-date-and-time/ Share on other sites More sharing options...
Guest Weirdan Posted November 15, 2003 Share Posted November 15, 2003 insert into sometable set somefield=now() ? Link to comment https://forums.phpfreaks.com/topic/1367-inserting-date-and-time/#findComment-4529 Share on other sites More sharing options...
antilectual Posted November 15, 2003 Author Share Posted November 15, 2003 cheers bud Link to comment https://forums.phpfreaks.com/topic/1367-inserting-date-and-time/#findComment-4536 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.