Lalit-Workz

This blog is all about me and my work till now....

Thursday, May 27, 2010

Date datatype does not display time when selected

Default date format is set to DD-MON-YY. This can be changed by running below sql.

alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss';
Posted by Unknown at 4:43 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Links

  • Google News
  • Program Library HOWTO
  • WarehouseOptimization

Blog Archive

  • ►  2012 (3)
    • ►  October (1)
    • ►  May (1)
    • ►  March (1)
  • ►  2011 (1)
    • ►  September (1)
  • ▼  2010 (3)
    • ►  July (1)
    • ▼  May (2)
      • Date datatype does not display time when selected
      • SQL Server 2005 Express and 2008 Express Side by Side
  • ►  2009 (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2008 (3)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
  • ►  2007 (17)
    • ►  December (3)
    • ►  November (1)
    • ►  September (3)
    • ►  July (1)
    • ►  June (7)
    • ►  April (2)
  • ►  2006 (11)
    • ►  November (1)
    • ►  July (4)
    • ►  June (2)
    • ►  May (4)
  • ►  2005 (1)
    • ►  December (1)
Awesome Inc. theme. Powered by Blogger.