MM/DD/YY

According to wikipedia, the only countries that use the MM/DD/YYYY system are the US, the Philippines, Palau, Canada, and Micronesia.

If you enter dates as numeric values in the format YYYYMMDD, then you can use the 30-day month method (also known as the 8870 technique) to subtract the dates. After subtracting the start date from the end date, if DD > 31, then subtract 70, and if MM > 12, subtract 8800. The result will be the age in YYMMDD format.

Data Types for Date and Time

How to format SQL Server dates with FORMAT function

1. Use the FORMAT function to format the date and time.
2. To get DD/MM/YYYY use SELECT FORMAT (getdate(), ‘dd/MM/yyyy ‘) as date.
3. To get MM-DD-YY use SELECT FORMAT (getdate(), ‘MM-dd-yy’) as date.
4. Check out more examples below.

The default Date format in a SQL Server DateTime column is yyyy-MM-dd….

1. DMY – dd/MM/yyyy. Ex: 13/06/2018.
2. YDM – yyyy/dd/MM. Ex: 2018/13/06.
3. MDY – MM/dd/yyyy. Ex: 06/13/2018.
4. YMD – yyyy/MM/dd. Ex: 2018/06/13.

How to get different date formats in SQL Server

1. Use the SELECT statement with CONVERT function and date format option for the date values needed.
2. To get YYYY-MM-DD use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 23)
3. To get MM/DD/YY use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 1)

That statement will convert the expression from varchar to datetime value using the specified style….Syntax.

To get the current date and time:

1. SELECT getdate();
2. CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
3. SELECT CONVERT(VARCHAR(10), getdate(), 111);
4. SELECT CONVERT(date, getdate());
5. Sep 1 2018 12:00:00:AM.
6. SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()));
7. CAST ( expression AS data_type [ ( length ) ] )

Java String to Date Example

1. import java.text.SimpleDateFormat;
2. import java.util.Date;
3. public class StringToDateExample1 {
4. public static void main(String[] args)throws Exception {
5. String sDate1=”31/12/1998″;
6. Date date1=new SimpleDateFormat(“dd/MM/yyyy”).parse(sDate1);
7. System.out.println(sDate1+”/t”+date1);
8. }