Changing date format

[pmartike]

Hi! I'm working with Microsoft SQL Database. X| Anybody knows how to change date format form code: Now it's MM/DD/YYYY but i want DD/MM/YYYY. :(( Thank you.:rose:

-------------------------------- visit: http://pmartike.deviantart.com/

[Muhammad Gouda]

I am familier with MS Access rather than SQL And to do that there, I choose my format in the database designe phase (Set the date field format to whatever you want). and do not need coding for this. I think SQL Server provides same thing

Mohamed Gouda Egypt

[Harini N K]

Hi Use SET DATEFORMAT See the example below: **Example 1 :** executes without any error use northwind go set dateformat dmy go select top 10 * from Orders where requireddate >= '15-08-1996' **Example 2 :** gives error use northwind go set dateformat mdy go select top 10 * from Orders where requireddate >= '15-08-1996'

Harini

[pmartike]

And this works from code in .NET? Thanks anyway! ;)

-------------------------------- visit: http://pmartike.deviantart.com/

[Md Mustafa]

just type cast datetimr to string and give parameter as your desire format like:- .ToString("dd/mm/yyyy");

Mohammad Mustafa

[pmartike]

this returns me a string like this: "10/46/2007" if i used for today's date.. :omg:

-------------------------------- visit: http://pmartike.deviantart.com/

[Vikram A Punathambekar]

mm represents minutes. Use MM for the month.

Cheers, Vıkram.

---

After all is said and done, much is said and little is done.

[pmartike]

thanks :-D

-------------------------------- visit: http://pmartike.deviantart.com/

[PIEBALDconsult]

Please consider using an ISO 8601 compliant format -- .ToString ( "yyyy-MM-dd" )

[pmartike]

Thanks! Problem solved :D

-------------------------------- visit: http://pmartike.deviantart.com/