Feeds:
Posts
Comments

Posts Tagged ‘date time to date’

 

SELECT CONVERT(VARCHAR(10),GETDATE(),120)

 

Example:

 

CREATE
TABLE DateTimeTest

(

Date_Column
datetime

)

GO

 

INSERT
INTO DateTimeTest(Date_Column)

SELECT
CONVERT(VARCHAR(10),GETDATE(),120)

GO

 

SELECT
* FROM
DateTimeTest

GO

 

Read Full Post »

%d bloggers like this: