oracle sql date format example

How SQL SERVER 2000 obtains the current system time with SQL statementsis to use GETDATE (); getdate in SQL () January 08, 2008 Tuesday 14:59A very powerful date format function in SQL Server Copy Code code as follows:

We often use a variety of date formats for some purpose. Of course, we can use string operations to construct various date formats, but why are there any ready-made functions? The default datetime format of the Chinese version of SQL Server is yyyy-mm-dd thh: mm: Ss. Mmm. For

A Date Field in the database has the following data. The SQL statement is as follows: Select age, money, birthday from userinfo Observe carefully that the date field has two formats, one with time and the other without time. In the project, it is likely that the format is adjusted due to changes in requireme

For years and Days "Day" is a single-digit case, the processing is not the same, ' YYYYMMDD ' format is not a problem, and the format ' yyyy-mm-dd ' form is not, please see:Sql> alter session Set Nls_date_format = ' Yyyy-mm-dd hh24:mi:ss ';Session altered.Sql> Select To_date (' 2007059 ', ' yyyy-mm-dd hh24:mi:ss ') from dual;Select To_date (' 2007059 ', ' yyyy-mm-dd hh24:mi:ss ') from dual*ERROR at line 1:O

the difference between the date format ' yyyy-mm-dd ' and ' YYYYMMDD ' in Oracle For the month-day "days" is a single case, processing is not the same, ' YYYYMMDD ' format is no problem, and the type ' YYYY-MM-DD ' format is not, please see:

CREATE OR REPLACE FUNCTION f_irt_date_yyyymmdd (ENTER VARCHAR2)/***** The Effective date format is YYYYMMDD, the input date format is: 16-jul-15 (date-month-year)* Example: 20151231******/RETURN VARCHAR2 isNiendate

), GETDATE (), 120): 2006-05-16 10:57:49Select CONVERT (varchar), GETDATE (), 121): 2006-05-16 10:57:49.700Select CONVERT (varchar), GETDATE (), 126): 2006-05-16t10:57:49.827Select CONVERT (varchar), GETDATE (), ():???? ?????? 1427 10:57:49:907amSelect CONVERT (varchar), GETDATE (), 131): 18/04/1427 10:57:49:920amSelect CONVERT (varchar (4), GETDATE (), 112): 2006DescriptionUsing CONVERT:CONVERT (data_type [(length)], expression [, style])ParametersExpression is any of the valid Microsoft®

DateTime is used in C. toString (yyyy-MM-dd), DateTime. toString (MMddyyyy), a date-to-String Conversion method, is useless in SQLserver, and thus a FUNCTION is written. dateTime in. net. the ToString (formatprovide) method is similar, but only the date part is implemented. DateTime is used in C. toString ("yyyy-MM-dd"), DateTime. toString ("MM/dd/yyyy"), a date-

Summary: We often use SQL date conversion, which lists all the code with date output as a stringOutput Format 2014-06-12Select CONVERT (varchar), GETDATE (), 23) Output format 2014-06-12 22:31:18The following are the various conversion