> When I run a query that has a timestamp field, How can I query on just the
> date. Time stamp puts in the min, hour, and sec. All I need is the year,
> month, and day.
>
> SELECT * FROM table_name WHERE date = '2003-08-25';
select * FROM table_name WHERE DATE_FORMAT(date,'%Y-%m-%d') = '2003-08
al Message -
From: "Antony Dovgal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 23, 2003 9:19 AM
Subject: Re: tellme Timestamp
> On Fri, 22 Aug 2003 17:14:38 -0500
> "Dan J. Rychlik" <[EMAIL PROTECTED]> wrote:
>
> > Hel
On Fri, 22 Aug 2003 17:14:38 -0500
"Dan J. Rychlik" <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I am trying to find out how I can change my timestamp(14) to timestamp(8).
use DATE fields instead.
or use DATE_FORMAT() with TIMESTAMP to get only date.
---
WBR,
Antony Dovgal aka tony2001
[EMA
