change date to include time

[scheetz]

Hello,

I have this script that adds links to a database. The date that the link was added is formatted link YYYY-MM-DD. The date code looks like this:

      $custom_fields_name .= $field;

  if($field=='date') { 
    $date = $this->db_connect->DBDate(time()); 
    $custom_fields_value .= $date;

I would like the date entered in the database(mysql) to include the time somehow so when i do a query with "order by date asc" it will display the link just entered first and so on. Right now the links entered on the same day are displayed with the first link entered on that date first.

Thanks,
scheetz