top of page

Timestamp to Date in PLSQL

  • Writer: Rumesh Aponso (RMAX)
    Rumesh Aponso (RMAX)
  • Nov 22, 2024
  • 1 min read
d_start_time_ := TO_DATE(TO_CHAR(start_time_, 'YYYY-MM-DD-HH24.MI.SS', 'NLS_CALENDAR=GREGORIAN'), 'YYYY-MM-DD-HH24.MI.SS', 'NLS_CALENDAR=GREGORIAN');

d_end_time_   := TO_DATE(TO_CHAR(end_time_,   'YYYY-MM-DD-HH24.MI.SS', 'NLS_CALENDAR=GREGORIAN'), 'YYYY-MM-DD-HH24.MI.SS', 'NLS_CALENDAR=GREGORIAN');

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page