Skip to main content

Find the default date format for your current session


For input and output of dates, every Oracle Database instance has a default date format model (also called a mask) that is set by the NLS_DATE_FORMAT initialization parameter. (Initialization parameters determine the default settings for Oracle Database instances. Users who have appropriate permissions can change some of these parameters on a per-database, per-instance, or per-session basis.) When you first query the data stored in a table column with a DATE datatype, Oracle Database displays it with a format mask of either DD-MON-YYYY or DD-MON-RR, depending on which is set as the default.

Comments

  1. Soft Solution22 February 2013 at 02:01

    Thanks to give information regarding your own experience in this IT Line Bespoke Software Solutions

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Reports - Changing the current mode (Confine or Flex)

To set or override Confine mode:  In the Paper Layout view, click  Confine On or Confine Off  in the toolbar to toggle the mode: On: child objects cannot be moved outside their enclosing parent objects. Off: child objects can be moved outside their enclosing parent objects. To set or override Flex mode:  In the Paper Layout view, click  Flex On or  Flex Off in the toolbar to toggle the mode: On: parent borders "stretch" when child objects are moved against them. The child object maintains the same distance from the side it moves against. Off: parent borders remain fixed when child objects are moved against them.
Post a Comment
Read more

Difference Between CASE and DECODE?

– CASE is a expression – DECODE is a function - CASE expression is ANSI SQL Statement - DECODE is specific to Oracle Syntax - CASE syntax contains WHEN and THEN  - DECODE will not have this - CASE allow expressions or Scalar Sub query Expressions inside the CASE statement - DECODE won't allow expressions inside the DECODE function
1 comment
Read more