storing system date in my sql

[poppy_123]

Hello guys, How i can store system date using mysql query

insert into table values('val1',system date here,'value2');

either I have to use now() function or else.


or
using default while creating table

create table abc('col1',system date here,'col2');

thanks.

[poppy_123]

Hello guys, How i can store system date using mysql query

insert into table values('val1',system date here,'value2');

either I have to use now() function or else.


or
using default while creating table

create table abc('col1',system date here,'col2');

thanks.

[hiddeninclouds]

Here is a timestamp in php which is day-year-second (day of the year-year-seconds in the day)

  $curtime = getdate();
  $curTimeInSec = ((($curtime['hours'] * 60) * 60) + ($curtime['minutes'] * 60) + $curtime['seconds']);
 //create a time stamp for database
      $timearray = array($curtime['yday'], $curtime['year'], $curTimeInSec);
      $dbtimestamp = implode("-", $timearray);

[hiddeninclouds]

Here is a timestamp in php which is day-year-second (day of the year-year-seconds in the day)

  $curtime = getdate();
  $curTimeInSec = ((($curtime['hours'] * 60) * 60) + ($curtime['minutes'] * 60) + $curtime['seconds']);
 //create a time stamp for database
      $timearray = array($curtime['yday'], $curtime['year'], $curTimeInSec);
      $dbtimestamp = implode("-", $timearray);

[pwaring]

If you store the system date as an INT datatype, you can use the UNIX_TIMESTAMP() function of MySQL to get the number of seconds since the epoch.

[pwaring]

If you store the system date as an INT datatype, you can use the UNIX_TIMESTAMP() function of MySQL to get the number of seconds since the epoch.

[Dhej]

If you store it as a MySQL timestamp you can convert it to whatever you like with DATE_FORMAT, DATE_ADD, DATE_SUB, UNIX_TIMESTAMP or whatever in the query and hand most of the processing over to a binary application rather than a interpreted script...

[Dhej]

If you store it as a MySQL timestamp you can convert it to whatever you like with DATE_FORMAT, DATE_ADD, DATE_SUB, UNIX_TIMESTAMP or whatever in the query and hand most of the processing over to a binary application rather than a interpreted script...