I use CURRENT_TIMESTAMP with DATETIME as the column type.
Thus just modify s/time()/CURRENT_TIMESTAMP/ should fix your woes.
Joel
http://cow.whyi.org
On Thu, 20 Mar 2003, Robert Maurency wrote:
> I've got a MySQL question for you.
>
> Is the php value suitable for a MySQL timestamp field?
>
On Thu, Mar 20, 2003 at 09:21:37AM +1100, Robert Maurency wrote:
> (I'm making the tranistion between ASP & Access to PHP and MySQL and am
> having a tough time with this GUI-less database.)
If you haven't tried phpmyadmin get it. It's brilliant for admining
your mysql databases and just keeps ge
An easy beginners solution to this is just to make date fields in mysql as
integer type instead of datetime.
Later on once you are more familar with the mysql functions you can use
them to convert to the unix timestamp that time() produces etc...
On Thu, 20 Mar 2003, Robert Maurency wrote:
>
Robert Maurency wrote:
OK Thanks for that. Clears things up a bit for me.
Would that also explain why my php format date script is returing:
02:14 19 Jan 2038
all the time?
Is there a neat php way to format a value like this 20030320085056 into
something readable for us mortals?
There are lot
This one time, at band camp,
Robert Maurency <[EMAIL PROTECTED]> wrote:
> Is there a neat php way to format a value like this 20030320085056 into
> something readable for us mortals?
sure, many ways, are you getting this timestamp from MySQL?
if so, you can do some funky stuff when SELECTing f
-
From: Del [mailto:[EMAIL PROTECTED]
Sent: Thursday, 20 March 2003 9:33 AM
To: Robert Maurency
Subject: Re: [SLUG] PHP MySQL help
Robert Maurency wrote:
> I've got a MySQL question for you.
>
> Is the php value suitable for a MySQL timestamp field?
No.
If you have a timestamp fie
I've got a MySQL question for you.
Is the php value suitable for a MySQL timestamp field?
The reason I ask is because I'm getting an odd result in my web content
publishing site.
I'm grabbing form data from a query string and inserting it into MySQL.
(NewsDate is a MySQL timestamp field)