Home Tutorial Database (RDBMS) Format Date Time pada SQL Server
Tutorial Master Komputer
Format Date Time pada SQL Server PDF Cetak E-mail
Ditulis oleh Idris   
Sabtu, 18 April 2009 09:25

SELECT CONVERT(VARCHAR, GETDATE(),1)    Hasil  =   04/18/09

SELECT CONVERT(VARCHAR, GETDATE(),2)    Hasil  =   09.04.18

SELECT CONVERT(VARCHAR, GETDATE(),3)    Hasil  =   18/04/09

SELECT CONVERT(VARCHAR, GETDATE(),4)    Hasil  =   18.04.09

SELECT CONVERT(VARCHAR, GETDATE(),5)    Hasil  =   18-04-09

 

SELECT CONVERT(VARCHAR, GETDATE(),8)    Hasil  =   00:38:55

SELECT CONVERT(VARCHAR, GETDATE(),9)    Hasil  =   Dec 30 2008 12:30:55:840AM

Comments (0)Add Comment

Write comment

busy