Geek asks and answers

Oracle Date column stores time but does not display it

I have an oracle database backend related to C # Visual Studio Application.

I have an INVOICE table that stores several dates.

In the user interface, I bind a DateTimePicker to these fields. The user selects both DATE and TIME. These values ​​are stored in the database and later retrieved, but I do not see the time in the Oracle interface.

C # DataSet Visualizer: enter image description here

View Oracle Data enter image description here

Note that both images look at the same table, first from Visual Studio, and then from Oracle. TIME is stored between sessions somewhere since it can be retrieved and populates the user interface control that this column is associated with:

enter image description here

, SQL ORACLE EXCEL, TIME ORACLE, EXCEL.

? - ?

+5
1

ok :)

TO_CHAR, .

+5

More articles:


All Articles