Update datetime field in sybase

NextResult Tds. Update not updating database In my sql server database I am using the detailsview. The update command passes without error but does not change the values in the database. It recognises the new values and the old values but does not change the database values. I am not doing eanything special but using the standard calls with the standard detailsview and everything else works.

Any ideas? This approach works great for all columns except those having a "datetime" data type Sybase system 11 does not have a pure "date" data type. We've put a breakpoint on the SQLpreview event and can see that no datetime column information is added to t DateTime problem in updating database I put this into script section.

It works fine when the database field is text, but not if the field is a date. How should I modify this code? Parameters "OrderNumber". Text I tried e. DateTime But not work. Please help. ThanksThanks in advance for the help. I will try to credit the ones who helped but most important is we really do sincer Active Oldest Votes. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. User will input a date format in "date1" ,e. And the program will attach a time info on the field during save, i. See related articles to this posting.

SetItem row, date1, temp Best regards! Patrick Leung wrote in message Similar Artilces: Problem with SetItem and datetime I have a field type is datetime in a datawindow that I'm trying to change the value of. The field's tab order is I have no problem modifying any other fields in the DW. BTW, this is a direct port of an application originally created in PowerBuilder 5 and I had no problems modifying the field in that application. Problem with SetItem and datetime I have a field type is datetime in a datawindow that I'm trying to change the value of.

SetItem for datetime in a Datawindow I am trying to use the setitem command in client side javascript to set the value of a datetime column in a Html datawindow. I am running PB 7. Datetime Field Problem Urgent!!! Collections; using System.

Web; using System. Security; using System. WebControls; using System. WebParts; using System. HtmlControls; using System. Net; using System. Text; using System. IO; using System. Open comandosql. ExecuteNonQuery comandosql. Close comandosql. The error is: System. SqlException: The conversion Update the timepart of datetime field in sql I have a datetime field named EntryDate in one of the tables.

I want to update the timepart of this field and provide a default time of AM if there is no time portion attached to this date field. How can i do this? NET 2.