Get Year/Month/Day/Hour/Minute value from SQL Server DateTime field

Let's assume 'EntryDate' is your database field name of type datetime.
SELECT DATEPART(YEAREntryDate ) AS Year FROM TABLE
SELECT DATEPART(MONTH, EntryDate ) AS Month FROM TABLE
SELECT DATEPART(DAY, EntryDate ) AS Day FROM TABLE
SELECT DATEPART(HOUR, EntryDate ) AS Hour FROM TABLE
SELECT DATEPART(MINUTE, EntryDate) AS Minute FROM TABLE
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s