inserting a timestamp
| From: | olinux | Date: | Thu, 19 Apr 2001 05:12:47 +0000 |
| Subject: | inserting a timestamp | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8682@lists.php.net to get a copy of this message | ||
hey all,
I am having a hell of a time getting a timestamp to insert correctly. it keeps coming up
00000000000000
here's what i have
$date_avail = mktime (0,0,0,$month,$day,$year);
$avail = date("F j, Y", $date_avail);
echo "Date Available: $avail";
this works fine and displays the date correctly
My insert statement is fine [no mistakes]
I insert $date_avail into the date_avail field which is type TIMESTAMP - when i inserti get a
0000000000000
If i change the field type of date_avail to VARCHAR it inserts correctly and i can reference it as
a timestamp and display correctly [a mysql db]
can anyone help, i guess that using varchar is fine, but i have wasted a half a day and am a little
pissed about this. I noticed that even when i try to change the date_avail field with phpmyadmin to
NOT NULL it changes to NULL - i think that this is the prob, but i do not know
thanks much
olinux