Friday, January 23, 2009

Get Month Name from SQL

Hitry this SQL query to get month name
SELECT ID,datename(month,PostDate) as Month FROM yourTable
where PostDate is field in my table of datetime type

Good Luck

No comments: