Insert date format in SQL via ASP

[Bansi_WADIA]

Hi. This is a kind of problem that am facing. I have made a website with HTML and ASP as the front end parameter where ASP is the dynamic content page. Also the back end is SQL. The thing is that I want to transfer the Date format inserted in the static form and has to redirect through the asp page to the sql data field database. How is it possible? Can you please help me out.

[MindSpace]

You need to actually look into what sort of coding has been implemented to redirect the dynamic content to the data field of the database. The connectivity for SQL database to the ASP is by OLEDB provider that is by Microsoft which would lend in connecting the page to the database via mentioning the source path. You need to check out for the type or the format that is been inserted.

[Modifier]

This is a clear issue related to the formatting of the date. The date does consists of 3 parameters and that is day, month, year. The format is basically in a specific form that would recommend us to make sure that what kind of pattern is been used. The SQL database might have a specific format may be like yy/mm/dd. And the data that you are trying to insert may be like dd/mm/yy. Check out for the following outputs. This might help you in letting to know the exact problem.

[Praetor]

The formatting issue is a big problem. You need to know well what kind of format does the sql database might take in. Basically the string values that has to be inserted in to the query database is quite set of an example. The example can be like mydate.Tostring("yy/mm/dd"). This is can be a format example that through which the Dynamic content can be redirected to the database.

[Katty]

The getdate() method would actually set the stream for the same thing in sql server. The method is like "Insert into Table(name, date) values('ss',getdate())". This is a kind of format through which you can make the thing possible for adding the values to the database. You can make the necessary ailments to be fulfilled as per the information given.