Click here to Skip to main content
15,868,349 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i was used this function to get default date, Getdate(),this function get the system short time

Format,this is okay,

but when i retrive this date i couldnt change the date format ..

"select colum1,convert(varchar(max),date,103) from table_name"
its not working..

Refer me plz

Thanks,

vijay
Posted
Comments
ArunRajendra 27-Sep-13 6:03am    
What do you mean by not working? getting error? result not as expected? be more clear.

1 solution

You should use getdate() instead of date in the convert function if you want to change the date format you have options. pls go through below link to check the options:

http://www.w3schools.com/sql/func_convert.asp[^]

if i am wrong please post what is the error you are getting
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900