[eluser]Unknown[/eluser]
i want to insert time and date along with post details ? how insert date and time in my database
[eluser]jedd[/eluser]
Stick with ISO 8601 for your date formats - apart from being implicitly sensible, it aligns (more closely) with MySQL's native format.
You may be better off generating your datestamps from within your database directly, using the NOW() function (in MySQL - there's probably comparable functions for other RDBMS's).
Mind, if you're asking this question, then you probably don't want to track timezones for different users, etc, so it's probably less important for you to have accurate date information.
[eluser]ray73864[/eluser]
I like to store date/times as an integer, and stick the seconds into that field, allows you to do anything you like when you pull it out then, display it however you like, change it around to and all.