웹 프로그래밍 노트

SELECT LEFT(“20140323”, 4) FROM sample;

> 2014

SELECT RIGHT(“20140323”, 4) FROM sample;

> 0323

SELECT SUBSTR(“20140323”, 1, 4) FROM sample;

> 2014

SELECT SUBSTR(“20140323”, 3) FROM sample;

> 140323