Could you please give me your advice

[abglorie]

I am declard a field name as date of birty - data type as date now I get a date in a textbox as dd/mm/yyyy format. but sqlserver as mm/dd/yyyy format how can i store into a table as my getting value as dd/mm/yyyy Please give me a source code in vb thanking you abglorie

[Colin Angus Mackay]

If you pass the date as a parameter rather than trying to inject it into the SQL String you won't have to worry about date formats. It will also give you an extra benefit of protecting you against SQL Injection Attacks. And this appears to be a database question - Why isn't it in the SQL Forum?

---

Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website

[N a v a n e e t h]

This is a presentation issue. SQL Server stores date in a particular format. You can change the format when selecting data. Use CONVERT function to format date.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

[ballameharmurali]

hello abglorie, in the database change the datatype of the datefieldname as varchar(50) u will get or in the query write it as select convert(varchar(10),getdate(),101) or 103 ok byee murali