RE: Implicit Date conversion problem

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 29 Oct 2002 07:28:59 -0800
Message-ID: <F001.004F6419.20021029072859@fatcity.com>

Sorry about that ... I am working on a sev-1 problem with Oracle (ora-904 error if anyone is interested).

Doesn't work means it doesn't return any data .... the working query returns correct number of rows. the trunc() syntax is right ... est_dt column stored date with hh:mi:ss set to 00:00:00. It has a companion column called est_tm that stores time as number of seconds since midnight.

Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Tuesday, October 29, 2002 10:24 AM To: ORACLE-L_at_fatcity.com; Jamadagni, Rajendra

What does "doesn't work" mean?

Wrong data?

Error message?

etc...??

Also the trunc(to_date('01-Jan-03','DD-Mon-YY')) is not quite right most likely.

It should probably be:

  trunc(to_date('01-Jan-03','DD-Mon-YY'))

  to_date('01-Jan-03 23:59:59','DD-Mon-YY' HH24:MI:SS')

or if used with a variable:

  trunc(mydate+1) - (1/86400)

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt

Received on Tue Oct 29 2002 - 09:28:59 CST