ORA-08186: invalid timestamp specified

while executing below query i got the following error message:
 AS OF TIMESTAMP to_timestamp(’03-10-2011 08:00:00′,’dd-mm-yyyy HH24:MI:SS’)
ERROR at line 1:
ORA-08186: invalid timestamp specified
Reason: Because NLS_DATE_FORMAT doesn’t set.
Solution: set NLS_DATE_FORMAT
ALTER SESSION SET nls_date_format = ‘dd-mm-yyyy hh24:mi:ss’;
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

  • Categories

  • Advertisements
%d bloggers like this: