News:

GinGly.com - Used by 85,000 Members - SMS Backed up 7,35,000 - Contacts Stored  28,850 !!

Main Menu

convert text data type to smalldatetime data type

Started by nandagopal, Dec 10, 2008, 06:35 PM

Previous topic - Next topic
Go Down Pages1

nandagopal

Dec 10, 2008, 06:35 PM
Modify your query to:

Code Block

SELECT rsbirthday = CAST(rsbirthday AS smalldatetime)

FROM panelists

or

Code Block

SELECT CAST(rsbirthday AS smalldatetime) rsbirthday

FROM panelists

or

Code Block

SELECT CAST(rsbirthday AS smalldatetime) as rsbirthday

FROM panelists




Go Up Pages1