Tarih bilgisini bileşenlerine ayırma
select getdate()Tarih,datepart(year,getdate())yil, datepart(month,getdate())ay
, datepart(day,getdate())gun, datepart(hour,getdate())saat
, datepart(minute,getdate())dakika, datepart(second,getdate())saniye
, datepart(millisecond,getdate())milisaniye
Çıktısı:
.
, datepart(day,getdate())gun, datepart(hour,getdate())saat
, datepart(minute,getdate())dakika, datepart(second,getdate())saniye
, datepart(millisecond,getdate())milisaniye
Çıktısı:
.
This entry was written by
and posted on
Salı, Eylül 25, 2007
and filed under
Bookmark the
permalink
.
Follow any comments here with the
RSS feed for this post
.
Post a comment
(
in a new window
)
Comment Form under post in blogger/blogspot