Ora 9i client nls_date_format setting

[DaPi]

Originally posted by kris123
Select ename from emp where
empdate=to_date('01-JAN-2005 01:30:50','DD-MON-YYYY hh:mi:ss');

I'd recommend 24hr clock for time comparisons: HH24:MI:SS

[kris123]

Good tips hun anyway i relay all these to our VB apps developers.
They also need it most.

[kris123]

You know, with your tips and help, they thought im super-genius in
oracle here in the office, like marist89 I hope they wont identify
me here

Thanks to all of you my dearests

[davey23uk]

god help your company then