Sql DateName

Sales Id Customer Id Sales Date Note
S001 C02 2010-05-20 -
S002 C03 2010-03-10 Cash
S003 C01 2010-01-02 -

select datename (weekday,salesdate)as [Tanggal Transaksi] from trans

select datename(dw,salesdate) as [Tanggal Transaksi] from trans

Thursday
Wednesday
Saturday

select datename(day,salesdate) as [Tanggal Transaksi] from trans
select datename(d,salesdate) as [Tanggal Transaksi] from trans
select datename(dd,salesdate)as [Tanggal Transaksi] from trans
20
10
2

select datename(month,salesdate) as [Tanggal Transaksi] from trans
select datename(mm,salesdate) as [Tanggal Transaksi] from trans
select datename(m,salesdate) as [Tanggal Transaksi] from trans
May
March
January

select datename(year,salesdate) as [Tanggal Transaksi] from trans
select datename(yyyy,salesdate) as [Tanggal Transaksi] from trans
select datename(yy,salesdate) as [Tanggal Transaksi] from trans
2010
2010
2010