SQLize Online / PHPize Online  /  SQLtest Online

select to_date ('23-11-05 00:25:46', 'dd-mm-yy hh24:mi:ss'); select DATEADD (day, 1, '23.07.24'); SELECT DATEADD(year, 1, '25.12.2017'); ALTER SESSION SET time_zone = '16:00'; ALTER DATABASE SET TIME_ZONE = '05:00'; select SESSIONTIMEZONE; select DBTIMEZONE; select CURRENT_TIMESTAMP || ' ' || sessiontimezone; select to_date ('23-11-+05 00:25:46', 'dd-mm-syy hh24:mi:ss'); create table a (a varchar (25), b date); insert into a values ('25.12.2023 11:25 PM', '27.12.2023 07:25 PM'); select * from a; insert into a (b) select a from a; select * from a; select '2023-12-25 15:25 AM'; select to_timestamp ('29-DEC-2023 11:05:36.306', 'dd-mon-yyyy hh:mi:ss.ff'); select to_date ('23-11-05 00:25:46', 'dd-mm-yy hh24:mi:ss'); select to_timestamp ('23-11-05 00:25:46', 'dd-mm-yy hh24:mi:ss'); select to_timestamp ('29-dEc-2023 3901', 'dd-mon-yyyy sssss'); select to_timestamp ('1-1-23 pm 11:5:6 001', 'dd-mm-yy pm hh:mi:ss ddd'); select to_date ('23-11-05 11:25:46 pm', 'dd-mm-yy hh:mi:ss pm'); create table t (id int constraint n null); alter table t drop constraint n; select to_timestamp ('07,21/2023 12:36:25', 'MM-dd.YYYY HH:MI:SS') as time; select to_date ('07,21/2023 friday', 'MM-dd.YYYY day'); select to_date ('07.21', 'MM-dd'); select to_date ('21-1961', 'dd-YYYY'); select to_date ('7.1925', 'MM-YYYY'); select to_timestamp ('2023-12/05 11:35:45.345', 'YYYY-MM-DD HH:MI:SS.FF'); select round (1/1292.7, 5);