Grab the time from php and concat the values Separate time from date [ is the time actually important?] and let mysql set it -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Francisco - São Paulo - Brazil Sent: Thursday, February 16, 2006 2:32 PM To: php-objects@xxxxxxxxxxxxxxx Subject: Insert in DATETIME field I have this: $day = substr($data_nascimento, 0, 2); $month = substr($data_nascimento, 3, 2); $year = substr($data_nascimento, 6, 4); How can I insert that in a DATETIME field in MySQL? /*----------------------------*/ When you have a hammer Everything looks like a nail. /*----------------------------*/ PHP Data object relational mapping generator http://www.metastorage.net/ Yahoo! Groups Links PHP Data object relational mapping generator http://www.metastorage.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/