Question

what are the different date and time formats available in BASE
​

Answer 1

When we setup a jdbc connection between base and MySQL ,the table in base uses the data format DD.MM.YY.hh.mm. It is of course possible to change the format and save the change.

Answer 2

There are many different type of date and time formats available in BASE.

Explanation:

• In base formats, output format was generates defaultes by input format.
• In system, internally, all date and time format values are stored as a number of seconds.
• Like date are stored as number of seconds and time also stored as number of seconds.
• For example time is 10:00:00 means, it is stored in the form of 36000 internally, which is 60 seconds x 60 minutes x 10 hours.
• For example dd-mmm-yy, dd-mmm-yyyy, dd.mm.yy, mm/dd/yyyy, yyyyddd, (name of the month) are the general form of date and time format and DATEw, DATEw,EDATEw,  ADATEw, JDATEw, MONTHw are the format type of date and time formats respectively.

To Learn More...

1.What are the different date/time format available in base

https://brainly.in/question/5419687

2.How many formats for displaying date and time.

https://brainly.in/question/16843178