This line of code do the job
CONVERT(varchar(10), [MyDateTimecolumn], 20) eg: select PKID,CONVERT(varchar(10), createdDate, 20) from tempTable
Sunday, October 26, 2014
How to convert DateTime to Date VarChar
This line of code do the job
Subscribe to:
Post 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...
0 comments:
Post a Comment