Apply To:
Microsoft SQL Server 2000
1. Example: Table "AbsensiHistory"
2. Run this query
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
select tglabsen,
replace(convert(char(15),tglabsen,106),' ','-') [Format-DD-MMM-YYYY]
from AbsensiHistory
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
