Home > MS SQL > Convert DateTime to Date MS SQL

Convert DateTime to Date MS SQL

select convert(varchar, getdate(), 105)

This convert datetime to date using sql query.

For detail refer

http://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

http://www.sql-server-helper.com/tips/date-formats.aspx

Advertisements
Categories: MS SQL Tags:
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: