Time and date variable formats
The following table shows the character sequences that
Time_date_format
uses to specify the format:Character sequences | Description | Example |
|---|---|---|
SD | Short date | 11/16/15 |
LD | Long date | Monday, November 16, 2015 |
SDT | Short date and time | 11/16/15 03:22:01 PM |
LDT | Long date and time | Monday, November 16, 2015 03:22:01 PM |
T | Time | 03:22:01 PM |
TSD | Time and short date | 03:22:01 PM 11/16/15 |
TLD | Time and long date | 03:22:01 PM Monday, November 16, 2015 |
Provide Feedback