|
Format Date Time pada SQL Server |
|
|
|
|
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
 |