You may want to strongly consider converting the data to a timestamp field type, but that's for down the road.

You want to do you search like any other range search you would do.
select * from orderheadr where orderid between "20030124000000" and "20030124999999"

You're saying you want to search on a range, but you are coding your query like searching for a similarity.


On Friday, January 24, 2003, at 12:33 PM, Chuck Barnett wrote:

Hi, I inherited a db that has a varchar(30) column that holds a date/time
stamp in the form of YYYYMMDDHHmmss (ex: 20030124093952)

Well I want to select a range based on the first 8 characters(YYYYMMDD).

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to