Home » SQL & PL/SQL » SQL & PL/SQL » Re: error from sql (win) prompt
Re: error from sql (win) prompt [message #37888] Tue, 05 March 2002 05:53
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
1. first option (better)

use explicit date conversion e.g. to_date(var..,format..)

2. second option

use set NLS_DATE_FORMAT=.....
and then compile
Previous Topic: Primary key and unique
Next Topic: How to list all fields in JDBC?
Goto Forum:
  


Current Time: Tue Apr 23 23:39:13 CDT 2024