ORACLE: the date field cannot be stored in hours, minutes, and seconds"

Source: Internet
Author: User

A small test was conducted:

Create Table vipr_airport_rule1
(
Airline varchar2 (2) not null,
Airport varchar2 (3) not null,
Start_time date not null,
End_time date not null,
Num number not null
)

Try to insert data:

Insert into vipr_airport_rule1 values ('CA', 'pek', to_date ('20170101', 'hh24mi '), to_date ('20170101', 'hh24mi'), 0000 );

Successful, but query:

SQL> select * From vipr_airport_rule1;
 
Airline airport start_time end_time num
------------------------------------------------------------------------------
CA pek 2012/9/1 2012/9/1 2: 300

You can only store the data in this format. However, only the time (hours, minutes, And seconds) can be obtained during query ):

SQL> select to_char (end_time, 'hh24mis') from vipr_airport_rule1;
 
To_char (end_time, 'hh24mis ')
----------------------------
020000
 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.