Convert asp.net date format to sql date format

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

Convert asp.net date format to sql date format

Author

Topic

edson
Starting Member

2 Posts

Posted - 2008-12-09 : 03:38:50

Hi,

I'm trying to send system date format of a user to database and convert it in a stored procedure and then store date in a database.
How can I change asp.net datetime format to sql datetime format.

Thanks,

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-09 : 03:54:16

By using proper DATETIME data type parameter.

E 12°55'05.63"
N 56°04'39.26"

edson
Starting Member

2 Posts

Posted - 2008-12-09 : 04:05:08

How can I set DateTime data type parameter if set this parameter by Crystal Report.


 _reportDocument = new ReportDocument();            _reportDocument.Load(Server.MapPath("CrystalReports\\Report1.rpt"));
.....
_reportDocument.SetParameterValue("@UserDate",userdate);
_reportDocument.SetParameterValue("@UserDateFormat",userdateformat);
....

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-09 : 06:17:52

You chose parameter datatype when you create the parameters.

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources