![]() ![]() The cid column is of NUMBER data type and helps to identify the method by which the data is entered. SQL> ALTER SESSION SET NLSDATEFORMAT'DD-MON-YYYY HH24:MI:SS' Create a table tabledt with columns cid and cdt. You should maybe check that the current value doesn't include a time, though the column name suggests it doesn't. Example 4-1 Inserting Data into a DATE Column. Since you aren't specifying a time component - all Oracle DATE columns include a time, even if it's midnight - you could also use a date literal: UPDATE PASOFDATE SET ASOFDATE = DATE '' Whether that is the problem or not, you should always specify the date model: UPDATE PASOFDATE SET ASOFDATE = TO_DATE('', 'MM/DD/YYYY') You could find out what it is, but it's better not to rely on the default or any implicit format models at all. Because of how it's displayed you're assuming that is MM/DD/YYYY, but it seems not to be. I would want it to change it so that it shows me the timestamp as well. ![]() When you query the date your client is formatting the date for display, as. When you try to update it it's using a default date format model. How to Change Date format style in SQL Developer 684389 edited Currently my date format looks like 13-FEB-09. Dates stored in the database do not have formats. Normally the same date format is used for selecting and updating dates, but in this case they appear to be different - so your client is apparently doing something more complicated that SQL*Plus, for example. This is based on the assumption that you're getting an error about the date format, such as an invalid month value or non-numeric character when numeric expected.ĭates stored in the database do not have formats. ![]()
0 Comments
Leave a Reply. |