Sql

select extract(day from systimestamp) from dual;

-- Will return 'November'
select to_char(to_date('15-11-2010', 'DD-MM-YYYY'), 'Month') from dual

SELECT
  TO_CHAR(DATE '2022-01-01', 'Day')
FROM DUAL;

PREVIOUS	NEXT

Code Example
Sql :: group concat with separator
Sql :: check mysql port
Sql :: sqlserver create table from select
Sql :: sql server check table exists
Sql :: drop table in mysql
Sql :: mysql update table from select on another table
Sql :: if then else sqlite
Sql :: find nth highest salary of an employee
Sql :: create sqlite database in laravel
Sql :: oracle trace session
Sql :: how to drop a trigger in postgresql
Sql :: delete index in postgresql
Sql :: strict in postgres SQL
Sql :: date to string sql
Sql :: show tables sql
Sql :: oracle list user grants
Sql :: access mysql command mac xampp
Sql :: postgres concat_ws
Sql :: insert pg result of select
Sql :: oracle like case insensitive
Sql :: How to Add a Default Value to a Column in MS SQL Server
Sql :: check postgresql port windows
Sql :: mssql how to insert more than 1000 rows
Sql :: convert date to datetime sql
Sql :: clone table structure mysql
Sql :: sql server obtener fecha en formato dd/mm/yyyy
Sql :: sql order by ascending
Sql :: sqlite show table definition
Sql :: where date = max(date) in sql
Sql :: allow external access to mysql