Setting Oracle date field

Setting Oracle date field

El Forum
Guest

02-23-2009, 10:40 AM

[eluser]jules123[/eluser]
Excellent! Thanks so much!

I read somewhere that it is better to set the NLS_DATE_FORMAT at the client side. So I am executing query "alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'" before my actual query and it's working fine Smile

Thanks again.

Messages In This Thread

Setting Oracle date field - by El Forum - 02-20-2009, 01:20 PM

Setting Oracle date field - by El Forum - 02-21-2009, 04:36 AM

Setting Oracle date field - by El Forum - 02-23-2009, 10:40 AM

Setting Oracle date field - by El Forum - 04-28-2009, 07:27 PM

Setting Oracle date field - by El Forum - 12-15-2009, 11:06 AM

Setting Oracle date field - by El Forum - 08-06-2010, 01:26 PM

Setting Oracle date field - by El Forum - 08-06-2010, 02:06 PM

Setting Oracle date field - by El Forum - 08-06-2010, 02:34 PM

Setting Oracle date field - by El Forum - 08-06-2010, 03:41 PM

Setting Oracle date field - by El Forum - 08-06-2010, 07:58 PM