At 14:57 -0600 2/1/02, Greg Peretti wrote:
>Hi, folks.
>
>I have what I hope is a simple problem. Hope someone can help.
>
>I have a database with a date field in the form 2002-02-01. I would like
>to be able to query the database to determine the day of year of an
>entry (the $yday variable in th
SELECT DATE_FORMAT(date_column, %j) AS newdate FROM table
$j = Day of year (001...366)
- Original Message -
Sent: Friday, February 01, 2002 1:57 PM
Subject: Determining day of year
Hi, folks.
I have what I hope is a simple problem. Hope someone can help.
I have a database with a
Angeles CA 90013
Phone: 213-593-1090 x107
Fax: 213-593-1091
-Original Message-
From: Greg Peretti [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 12:57 PM
To: [EMAIL PROTECTED]
Subject: Determining day of year
Hi, folks.
I have what I hope is a simple problem. Hope someone ca
Hi, folks.
I have what I hope is a simple problem. Hope someone can help.
I have a database with a date field in the form 2002-02-01. I would like
to be able to query the database to determine the day of year of an
entry (the $yday variable in the localtime function in Perl). February 1
would be