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:
> I've got a MySQL question for you.
>
> Is the php value <?echo time();?> 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)
>
> $query = "INSERT INTO News(Headline, Story, Status, Author,
> NewsDate) VALUES('" . $_GET['Headline'] . "', '" . $_GET['Story'] . "', '" .
> $_GET['Status'] . "', '" . $_GET['Author'] . "', '" . time() . "')";
>
> This query works fine, but when I view the information on my news page the
> date returned ($row->NewsDate) is:
>
> 00000000000000
>
> Which formatted with this function <?echo date("h:i d M Y",
> $row->NewsDate);?> returns:
>
> 11:00 01 Jan 1970
>
> If I leave the time() function out of my insert statement then the returned
> value is:
>
> 20030320084636 or (02:14 19 Jan 2038)
>
> Does anyone know what is going on here?
> Any help, much appreciated.
> Rob
> (I'm making the tranistion between ASP & Access to PHP and MySQL and am
> having a tough time with this GUI-less database.)
>
>
> *************************************************************
> This mail, including any attached files may contain
> confidential and privileged information for the sole
> use of the intended recipient(s). Any review, use,
> distribution or disclosure by others is strictly prohibited.
> If you are not the intended receipient (or authorised to
> receive information for the recipient), please contact
> the sender by reply e-mail and delete all copies of
> this message.
> *************************************************************
>
--
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug
