select abc AS date from mytables;
Simon
-Original Message-
From: Alec Smith [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 09:30
To: Don Read
Cc: [EMAIL PROTECTED]
Subject: RE: Proper date query conversion structure?
Ok, dumb mistake... Remind me not to code so late at night. :)
With
Ok, dumb mistake... Remind me not to code so late at night. :)
With that fixed, I now get
mysql> select DATE_FORMAT(post_timestamp, '%M %d, %Y') from guestbook;
+--+
| DATE_FORMAT(post_timestamp, '%M %d, %Y') |
+--+
On 04-Jun-01 Alec Smith wrote:
> What would be the correct query to convert a date stored in MySQL in
> a
> DATETIME field to month_name month_date, year format at the same time
> I'm
> pulling a bunch of other data from the same row as the field with the
> date I need converted? I've tried somet
What would be the correct query to convert a date stored in MySQL in a
DATETIME field to month_name month_date, year format at the same time I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something like the below without
success:
SELECT
