c How to convert the time function from 2012 07 23 to 2012 07 23 format

Is your "2012-07-23" a field? If you can directly use the substitution function to replace the year, month and day with "-", it will save trouble.

You can also go to your computer and set your computer's time format, or use it.

If datetime type, directly. tostring("yyyy-mm-dd");

If it is of the string type, it will be changed to datetime first, and then it will be changed to datetime. tostring("yyyy-mm-dd");

String truncated, followed by '-'

What I said upstairs and everyone should have been able to solve the landlord's problem.

You select the cell format, and the date you select *March 4, 2001.

That format. That's it.

Suppose you type the date 23 02 2012 in cell A1, put the conversion date in cell B1, and type the formula =right(b1,4)& in cell B1"years"&mid(b1,5,1)&"month"&left(b1,2)&"day"to convert the date to February 23, 2012.

Format the cell --- date --- choose the format you want.

Right-click to format the cells and choose the appropriate one.

wjrwww21 correct solution,You try it,Hehe。

Let's start from February to June, where 2012 is a leap year, so February has 29 days, 3 May, 31 days each, 4 June, 30 days, and it adds up to 29 + 31 * 2 + 30 * 2 = 151 days, 31 days in January, and 31 days on the 23rd, and then 31-23 = 8 days, plus 23 days in July, 151 + 8 + 23 = 182 days, this answer should be correct!

Your 07-Jun-12 pm should be of the timestamp type.

Do you want to modify it uniformly:

update table name set your time field = to date(trunc).'yyyy-mm-dd');

Then all the time for this table has been changed, and you'd better make a backup first.

select to_char(cast(systimestamp as date),'yyyy-mm-dd') from dual;

Replace systimestamp with the time you want to convert to 07-Jun-12

From 2013 to 1015, there are three years, 365*3=1095 days.

2012 is a leap year, 366 days, minus January 1-22, a total of 22 days, there are still 366-22 = 344 days.

In 2016, there were 31 days in leap years, 29 days in February, 30 days in February, and 23 days from July 1 to 23.

A total of 1095 + 344 + 31 * 3 + 29 + 30 * 2 + 23 = 1644 days, I hope it will help you!

There are 472 days from 00:00 on April 8, 2012 to 24:00 on July 23, 2013.

Detailed description: including the first and last 472 days;

excluding the first 471 days;

471 days excluding the end (i.e. countdown);

It does not include the first and last (i.e. intervals) of 470 days.

Programming to solve accurately!

471 days, note: the head is not counted, and the end is not counted.

Here's how to calculate it in excel:

The 1 datedif calculation returns the difference between the two date parameters. Calculate the number of days 2 First enter the date of joining the work 2012 04 08 in a cell (such as B2 cell) in the excel worksheet, enter the calculation date 2013 07 23 in another cell (such as B3 cell), then move the cursor to the cell where you want to store the calculation result (such as B4 cell), right-click the B4 cell, select "Format Cell" in the shortcut menu, select the number type as "Numeric" type, and set the number of decimal places to 0. Finally, enter the formula =b3-b2 in this cell, and the number of days 471 in the two-day period after entering will be automatically calculated.

Including 2012-04-08 and 2013-07-23472 days; 471 days excluding April 8, 2012.

It is a total of 472 days, and the accuracy is guaranteed.