Table of Contents

Search

  1. Preface
  2. Function reference
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. System variables
  8. Datatype reference

Function Reference

Function Reference

SSSSS format string

SSSSS format string

The following expression converts strings that include the seconds since midnight to date values:
TO_DATE( DATE_STR, 'MM/DD/YYYY SSSSS')
DATE_STR
RETURN_VALUE
12/31/1999 3783
12/31/1999 01:02:03
09/15/1996 86399
09/15/1996 23:59:59

0 COMMENTS

We’d like to hear from you!