DB2 Timestamp vs DateTime RRS feed

  • Question

  • Hi.

    My UI displays result of DB2 query which is using SELECT * FROM myTable. Within result there are columns with DB2 data types DATE and Timestamp. In C# result these columns returned as DateTime (ex. 03/29/2019 12:00 am). How to correctly Select these columns so the data in it would be as it stored in DB2 table: Date and Timestamp in order to correctly display it on Web page?

    Tuesday, June 18, 2019 7:06 PM

All replies

  • this forum is for writing HTML/js/CSS for IE. If you need help in fixing your C# code, you are in the wrong forum. 

    I am not sure what database access technology you are using. You can talk a look at the forums under the Data Platform Development category if you are using ADO.Net, except Entity Framework whose support moved to 

    Visual C++ MVP

    Tuesday, June 18, 2019 10:08 PM