Hi, Depends on what type of timestamp you are looking at. But in general, you use the mysql built in function: now() and if you want to convert that into unix_timestamp, unix_timestamp(now()) will do the trick.
mysql> select now(); +---------------------+ | now() | +---------------------+ | 2001-12-05 14:31:06 | +---------------------+ mysql> select unix_timestamp(now()); +-----------------------+ | unix_timestamp(now()) | +-----------------------+ | 1007533917 | +-----------------------+ REPLACE formtable VALUES (now(),data here....); or REPLACE formtable VALUES (unix_timestamp(now()),data here....); jaime At 11:25 PM 12/4/01 -0700, *Himerus* wrote: >Can anyone give me a good link on how to put in a timestamp on a form >that inserts directly into a sql database??? I keep trying it, but it's >only coming thru as 00000000000000 , so on. > > >Thanks. >Newbie Jake. > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
