This line of code do the job
CONVERT(varchar(10), [MyDateTimecolumn], 20) eg: select PKID,CONVERT(varchar(10), createdDate, 20) from tempTable
Showing posts with label Convert DateTime to Date. Show all posts
Showing posts with label Convert DateTime to Date. Show all posts
Sunday, October 26, 2014
How to convert DateTime to Date VarChar
This line of code do the job
Subscribe to:
Comments (Atom)
Popular Posts
-
Full screen Overlay Effects When you search for a solution for fullscreen overlay, most website provide solutions using JavaScrip... -
Android studio Error occurred during initialization of VM Could not reserve enough space for object heap Error: Could not create the ... -
Unity Assets List : Complete Projects : Color Switch Clone : Must have for the beginner, you will learn a lot form thi...
-
DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(dt); var list = dt.AsEnumer... -
If this issue happens after the website is uploaded to server and no problem at your local computer, the cause of error is the date format... -
Hostgator Offers Check Whole table If you want to check if a null value exists in the table you can use this method: public ... -
In Web.config under <configuration> Tag <connectionStrings> <add name = "ConnStringDb1" connec...
-
Resolve the culture Splitted the functionality up into two methods. The first one resolves the CultureInfo based on the browsers langu...
-
While working with files and directory we need read write permission on files and folders, this can be done by manually giving access perm...
-
We need to convert the Datatable dt to Array of objects StudentListResponse DataTable dt = new DataTable(); SqlDataAdapter da = new SqlD...
Share
Popular Posts
-
Full screen Overlay Effects When you search for a solution for fullscreen overlay, most website provide solutions using JavaScrip... -
Android studio Error occurred during initialization of VM Could not reserve enough space for object heap Error: Could not create the ... -
Unity Assets List : Complete Projects : Color Switch Clone : Must have for the beginner, you will learn a lot form thi...
-
DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(dt); var list = dt.AsEnumer... -
If this issue happens after the website is uploaded to server and no problem at your local computer, the cause of error is the date format... -
Hostgator Offers Check Whole table If you want to check if a null value exists in the table you can use this method: public ... -
In Web.config under <configuration> Tag <connectionStrings> <add name = "ConnStringDb1" connec...
-
Resolve the culture Splitted the functionality up into two methods. The first one resolves the CultureInfo based on the browsers langu...
-
While working with files and directory we need read write permission on files and folders, this can be done by manually giving access perm...
-
We need to convert the Datatable dt to Array of objects StudentListResponse DataTable dt = new DataTable(); SqlDataAdapter da = new SqlD...