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 Quote 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() ? Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/1367-inserting-date-and-time/#findComment-4536 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.