From: Douglas Brantz
Date: March 21 1999 9:40pm
Subject: Re: Timestamp or Datetime?
List-Archive: http://lists.mysql.com/mysql/741
Message-Id: <36F56740.15A4DB61@appstate.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



> Time Stamp display in web page:

Can I use the following script to display info from timestamp in a web page?
d is my field for timestamp.
Would this script would be placed where you need the date display?

my $sth2 = $dbh->Query("select curday(d),curmonth(d),curdate(d) from y2k where
ticknum=ticketnum")
or die $Mysql::db_errstr;
while (@record = $sth2->FetchRow)  {
$curday = $record[0]; $bar = $record[1];
}
print $curday

Thanks,

Douglas Brantz
ASU
brantzdr@stripped

PS, is this the right listserve for this type of question and if not can anyone
recommend a good listserve for cgi & perl coding for displaying info from mysql.