Date Time Format
Batch format dates and times to unified format
Tool Guide
About This Tool
The online date and time formatting tool can batch-format times or dates into a unified format. If time parsing fails, the original time string is returned.
Example format: YYYY-MM-DD HH:mm:ss, which will generate a time similar to 1962-08-30 03:58:58; you can combine the codes yourself according to your actual needs.
Format code, description, return value: M month as a number without leading zero 1-12; MM month as a number with leading zero 01-12; MMM month as a three-letter abbreviation Jan-Dec; MMMM month, full text format January-December; Q quarter 1-4; D day of the month without leading zero 1-31; DD day of the month with leading zero 01-31; d day of the week as a number 0-6, 0 for Sunday, 1-6 for Monday through Saturday; ddd day of the week as three letters Sun-Sat; dddd day of the week, full text format from Sunday-Saturday; w week of the year, e.g. 27 means the 27th week; YYYY full year as four digits, e.g. 2021; YY year as two digits, e.g. 21; A uppercase AM PM AM PM; a lowercase am pm am pm; HH hour, 24-hour format, with leading zero 00-23; H hour, 24-hour format, without leading zero 0-23; hh hour, 12-hour format, with leading zero 00-12; h hour, 12-hour format, without leading zero 0-12; m minute, without leading zero 0-59; mm minute, with leading zero 00-59; s second, without leading zero 1-59; ss second, with leading zero 01-59; X Unix timestamp 1298372741