Sql

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT sysdate FROM dual;

SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;

SELECT
  TO_DATE( '24-JUL-21', 'DD-MON-RR' )
FROM
  dual;

 e.g., 01-JAN-17

PREVIOUS	NEXT

Code Example
Sql :: sql server alter table add column datetime default current_timestamp
Sql :: oracle nls session
Sql :: duplicate column values sql
Sql :: mysql f# examples
Sql :: sql delete stored procedure
Sql :: postgresql get last day of month
Sql :: postgres show current role
Sql :: create policy in sql
Sql :: mqtt Error: Address not available
Sql :: psql: error: FATAL: role "postgres" does not exist
Sql :: connect mysql docker
Sql :: mysql get character set
Sql :: convert series number to date in sql
Sql :: t-sql select min from two values
Sql :: sql last week
Sql :: sql sample tables with data
Sql :: postgresql group by month and year
Sql :: sql today at midnight
Sql :: transalations from sql to Linq count and group by
Sql :: create sequence if not exists postgres
Sql :: PL SQL MODIFY COLUMN NME
Sql :: postgres count string length
Sql :: how to get table current identity value in sql server
Sql :: wsl install mysql
Sql :: insert pg result of select
Sql :: An error occurred while installing mysql2 (0.5.3)
Sql :: how to check if the view exists in sql server
Sql :: ajouter une clé etrangere mysql
Sql :: python sqlite3 prepared statement
Sql :: enable service broker in sql server