storing system date in my sql

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

Code:

---

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

---

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


or
using default while creating table

Code:

---

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

---

thanks.

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

Code:

---

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

---

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


or
using default while creating table

Code:

---

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

---

thanks.

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

Code:

---

  $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);

---

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

Code:

---

  $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);

---

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.

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.

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...

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...