Horje
oracle sql timestamp Code Example
oracle current timestamp 
-- In SESSION time zone
SELECT current_timestamp FROM dual;     -- 2021-05-07 05:36:57.476000
SELECT current_timestamp(2) FROM dual;  -- 2021-05-07 05:36:57.470000
SELECT current_date FROM dual;          -- 2021-05-07 05:36:57
-- In SYSTEM on which database resides
SELECT systimestamp FROM dual;          -- 2021-05-07 07:36:57.762000 +02:00
SELECT sysdate FROM dual;               -- 2021-05-07 07:36:57
Source: stackoverflow.com
oracle sql timestamp 
to_timestamp('2022-03-12 21:24:00', 'yyyy-mm-dd hh24:mi:ss')
to_date('2022-03-12 21:24:00', 'yyyy-mm-dd hh24:mi:ss')
Source: stackoverflow.com



Sql

Related
write sql query to show the details start from digit Code Example write sql query to show the details start from digit Code Example
sql substring before last occurrence of character Code Example sql substring before last occurrence of character Code Example
get first match in each group mysql query Code Example get first match in each group mysql query Code Example
oracle create package body Code Example oracle create package body Code Example
sql server last character in string Code Example sql server last character in string Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje