My notes and Other stuff:

The things, I came across. {{For my own reference}}

Showing posts with label Date Foramt. Show all posts
Showing posts with label Date Foramt. Show all posts

Monday, 21 September 2009

How to change date format in oracle?

ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY hh:mi:ss AM';


Ref links:

http://www.dba-oracle.com/sf_setting_parameters_tips.htm
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:351017764854
Posted by Thillakan at Monday, September 21, 2009 No comments:
Labels: Date Foramt, Oracle
Older Posts Home
Subscribe to: Posts (Atom)

Search

Blog Archive

  • ▼  2018 (1)
    • ▼  January (1)
      • Softwares & Tools
  • ►  2017 (2)
    • ►  September (1)
    • ►  April (1)
  • ►  2015 (4)
    • ►  April (1)
    • ►  March (2)
    • ►  February (1)
  • ►  2014 (5)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2013 (8)
    • ►  December (1)
    • ►  November (2)
    • ►  July (2)
    • ►  April (1)
    • ►  March (2)
  • ►  2012 (6)
    • ►  November (1)
    • ►  August (1)
    • ►  July (1)
    • ►  May (1)
    • ►  February (2)
  • ►  2011 (8)
    • ►  December (2)
    • ►  September (1)
    • ►  July (1)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2010 (3)
    • ►  December (1)
    • ►  June (1)
    • ►  April (1)
  • ►  2009 (30)
    • ►  December (1)
    • ►  November (5)
    • ►  October (4)
    • ►  September (15)
    • ►  August (3)
    • ►  June (1)
    • ►  March (1)
  • ►  2008 (7)
    • ►  November (4)
    • ►  October (2)
    • ►  September (1)
  • ►  2006 (1)
    • ►  November (1)

About Me

My photo
View my complete profile

My Profile

View Thillakan Sabanayakam's profile on LinkedIn

StackOverFlow


profile for Thillakan at Stack Overflow, Q&A for professional and enthusiast programmers
Ethereal theme. Powered by Blogger.