About Translate DateTime Format
Parses a datetime string in one format and re-writes it in another. Run with no input to see the relevant format string examples.
Input: text. Output: text.
Format reference: Translate DateTime Format background and specification
Example
Use “Try example” to load this public sample and its settings, then run it.
Settings used in this example
| Parameter | Example value | Input and choices |
|---|---|---|
| Built in formats | "Standard date and time" | Text7 Available choices
|
| Input format string | "DD/MM/YYYY HH:mm:ss" | Escape sequences such as \n, \r and \t are supported |
| Input timezone | UTC | Text598 Available choices
|
| Output format string | "dddd Do MMMM YYYY HH:mm:ss Z z" | Escape sequences such as \n, \r and \t are supported |
| Output timezone | UTC | Text598 Available choices
|
Input
01/04/1999 22:33:01
Result
Thursday 1st April 1999 22:33:01 +00:00 UTC
Parameters
| Parameter | Default value | Input and choices |
|---|---|---|
| Built in formats | "Standard date and time" | Text7 Available choices
|
| Input format string | "DD/MM/YYYY HH:mm:ss" | Escape sequences such as \n, \r and \t are supported |
| Input timezone | UTC | Text598 Available choices
|
| Output format string | "dddd Do MMMM YYYY HH:mm:ss Z z" | Escape sequences such as \n, \r and \t are supported |
| Output timezone | UTC | Text598 Available choices
|
Before interpreting the result
Check seconds versus milliseconds and specify the expected timezone. A timestamp identifies an instant; a formatted local date may be ambiguous around daylight-saving transitions.
How to use this page
- Paste your input or open a local file.
- Adjust tool options if needed, then choose Run tool.
- Copy the result or download the original output bytes.
Inputs and results are not added to the public catalogue or saved in the URL. Processing happens in your browser; HTTP Request and DNS over HTTPS send the requests you explicitly run. Files up to 128 MiB can be opened; decompression and image tools may have smaller processing limits. Large results have a shortened preview. Text and HTML downloads use UTF-8; binary downloads preserve output bytes. Pasted text follows browser newline handling; open a file when exact input bytes matter.