Re: Oracle date format

2009-07-10 Thread Rob Wolfe
On Fri, July 10, 2009 08:41, Brock wrote: > > Vendor code: 1861 > > On Jul 9, 7:16 pm, Rob Wolfe wrote: >> On Jul 9, 4:56 pm, Brock wrote: >> >> > I have some date in Oracle that are stored in this format 5/13/2008 >> > 11:10:53 AM ... I'm trying pass a variable into Oracle from a Crystal >> > R

Re: Oracle date format

2009-07-10 Thread Brock
Vendor code: 1861 On Jul 9, 7:16 pm, Rob Wolfe wrote: > On Jul 9, 4:56 pm, Brock wrote: > > > I have some date in Oracle that are stored in this format 5/13/2008 > > 11:10:53 AM ... I'm trying pass a variable into Oracle from a Crystal > > Report... I'm using "and trunc(b.create_time) = to_date

Re: Oracle date format

2009-07-09 Thread Rob Wolfe
On Jul 9, 4:56 pm, Brock wrote: > I have some date in Oracle that are stored in this format 5/13/2008 > 11:10:53 AM ... I'm trying pass a variable into Oracle from a Crystal > Report... I'm using "and trunc(b.create_time) = to_date(p_date, 'DD- > Mon-');" but I keep getting "Failed to retriev

Oracle date format

2009-07-09 Thread Brock
I have some date in Oracle that are stored in this format 5/13/2008 11:10:53 AM ... I'm trying pass a variable into Oracle from a Crystal Report... I'm using "and trunc(b.create_time) = to_date(p_date, 'DD- Mon-');" but I keep getting "Failed to retrieve data from the database"... any formatti