So both columns contain the same value right?īoth DATE and TIMESTAMP columns contain a time component, which does not match in this case. INSERT INTO t1 VALUES (TRUNC(SYSDATE), SYSDATE) The following examples use the DATE type, but the issues apply equally to the TIMESTAMP type. In the process, they often miss out very important information that can confuse you if you are not careful. What you see on screen from a query is what's in the database right? Well actually, that is often not the case.Ĭlient tools, like SQL*Plus, convert datetime column values into something much nicer to look at. The vast majority of problems people encounter are because of a misunderstanding about how dates are stored in the database. The way the Oracle database handles datetime values is pretty straightforward, but it seems to confuse many client-side and PL/SQL developers alike.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |