-
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:
Hello All,
I am trying to find out how I can change my timestamp(14
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-25
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
[EMAIL