• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql

how to convert string type to timestamp type in oracle sql plsql

Oracle TO_TIMESTAMP_TZ Function

November 2, 2012 by techhoneyadmin

Oracle To_TimeStamp_Tz Function

Oracle TO_TIMESTAMP_TZ Function is used to convert string type to time stamp type along with the time zone. Oracle TO_TIMESTAMP_TZ Function Syntax SELECT TO_TIMESTAMP_TZ(string_value, [FORMAT_MASK],[NLS_LANGUAGE]) FROM table_name; In the above Oracle TO_TIMESTAMP_TZ Function Syntax STRING_VALUE is the value that will be converted into date format. FORMAT_MASK is an optional field, if present; it is used […]

Filed Under: function Tagged With: how to convert string type to timestamp type in oracle sql plsql, How to use oracle sql plsql TO_TIMESTAMP_TZ function with example, TOTIMESTAMPTZPLSQL, What is oracle plsql TO_TIMESTAMP_TZ function

Copyright © 2022 · Parallax Pro on Genesis Framework · WordPress · Log in