[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Date problem
From:       Kole Dunn <kole () arialnet ! net>
Date:       2000-02-01 16:52:24
[Download RAW message or body]

Here's my insert statement:
$dbh->do("INSERT INTO impact VALUES ($qty, '$sku', '$product', 
$price, $sub, $date, $this_uid, NULL) ");

I've also tried this to get the date, inserted using the $date 
variable, with the same result:

($Second, $Minute, $Hour, $DayOfMonth, $Month, $Year, $WeekDay, 
$DayOfYear, $IsDST) = localtime(time);
$RealMonth = $Month + 1;
$date = "$Year$RealMonth$DayOfMonth";

$dbh->do("INSERT INTO impact VALUES ($qty, '$sku', '$product', 
$price, $sub, $date, $this_uid, '$date') ");

Kole



>On Tue, Feb 01, 2000 at 07:10:38AM -0800, Kole Dunn wrote:
> > I have a date column that displays 2001-00-21 instead of 2000-2-1.
> > Yesterday, it showed the year as 2010. Anyone know what's going on?
> > The date is correct on my machine. Here is the results of SHOW FIELDS...
>
>	How about showing us the INSERT statement? The date there
>might be in the wrong format.
>
>--
>						crawford@iac.net
>
>"The bullets are just his way of saying 'Keep it down, I've got a
>hangover.'"


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread26152@lists.mysql.com

To unsubscribe, send a message to:
    <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]