I apologize for this, But how exactly do I that?
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'; ----- Original 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: > > > 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 PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
