Sql

select to_date(20150302,'yyyymmdd') from dual;

or

select to_char(to_date(20150302,'yyyymmdd'),'mm/dd/yyyy') from dual;

PREVIOUS	NEXT

Code Example
Sql :: is not numeric sql
Sql :: search for replace in mysql
Sql :: cheatsheet for sql
Sql :: postgres set column equal to another
Sql :: update from table tsql
Sql :: rename database in sql
Sql :: postgresql casting integer to string
Sql :: how to use rank function in sql
Sql :: sql server locks
Sql :: mysql update with subquery
Sql :: create table in microsoft sql server
Sql :: add column text sql after column
Sql :: create sequence postgres
Sql :: sql server output parameter
Sql :: generate a random otp in sql server
Sql :: mysql set last_insert_id
Sql :: mysql where not equal
Sql :: sql foreign key
Sql :: sql date format
Sql :: how to query without duplicate rows in sql
Sql :: foreign key constraint in ms sql
Sql :: oracle list grants on package
Sql :: codigo crear tablas sql server
Sql :: oracle sql drop column if exists
Sql :: Check database restore status sql script
Sql :: how to check if a column is null in sql
Sql :: mssql dockere
Sql :: sqlite unique
Sql :: oracle partition table row count
Sql :: how to get date in sql