Posted by Hugo Kornelis on 09/30/05 22:59

On 30 Sep 2005 04:12:28 -0700, trint wrote:

>Ok,
>What format is this to where I can't find records (that I know are
>there) using this date "2005-09-29 23:58:00".
>Here is the SELECT that I use that doesn't work:
>
>SELECT * FROM RMA_HEADER
>WHERE CREATED_DATE LIKE '2005-09-29%'
>
>Any help is appreciated.
>Thanks,
>Trint

Hi Trint,

If the Created_Date is of datetime format, then use

SELECT Col1, Col2, ... -- Don't use SELECT * !!!
FROM RMA_Header
WHERE Created_Date >= '20050929'
AND Created_Date < '20050930'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

• Next in forum: Calling a Data Pump task from DTS?
• Prev in forum: Re: Multiple level nested Corelated query
• Thread view: Re: Can't "SELECT" using CREATED_DATE column...help

[Reply to this message]