SQL Timestamp Converter
Convert between a standard SQL TIMESTAMP/DATETIME string ('YYYY-MM-DD HH:MM:SS') and a regular date - useful for debugging database values and writing queries.
Recommended Settings
Pro Tips
- •Edit either the SQL timestamp string or the date/time field - the other one updates automatically
- •Use the Copy buttons to grab any value in the format you need, including Unix seconds, milliseconds, or ISO 8601
- •Click Use Current Time to instantly see the current moment represented in this format
- •This runs entirely in your browser - nothing you enter is sent to a server
Most Popular
Most users paste in a raw value from a database or log file to see what date and time it actually represents
When to Use This Tool
Convert a raw SQL timestamp string into a readable date and time.
Work backward from a known date to the equivalent SQL timestamp string.
Quickly verify what a specific timestamp value actually represents.
Figure out why a timestamp value looks wrong by converting it to a human-readable date.
How It Works
Take the SQL timestamp string you enter, which represents the standard 'YYYY-MM-DD HH:MM:SS' format used by TIMESTAMP and DATETIME columns in most SQL databases
Convert it to a standard Unix millisecond timestamp using the correct epoch offset and unit scale
Display the result in several common formats, and support converting in the opposite direction too
100% Private
Files never leave your device. All processing happens locally in your browser.
Lightning Fast
Powered by Client-side epoch arithmetic for optimal performance on modern browsers.
Open Source
Built with verified, open-source libraries. Fully transparent.
Frequently Asked Questions
What epoch does this format use?
The standard 'YYYY-MM-DD HH:MM:SS' format used by TIMESTAMP and DATETIME columns in most SQL databases.
Why would I need to convert this format?
This tool treats the SQL timestamp as UTC for the conversion, since SQL TIMESTAMP/DATETIME columns don't store timezone information themselves - your database or application layer is responsible for tracking which timezone the stored value represents.
Is my data sent to a server?
No. All conversion happens entirely in your browser using JavaScript.
Does this account for timezones?
The underlying timestamp is timezone-independent (a single point in time), and the 'Date & Time' field shows it in your browser's local timezone alongside UTC for reference.
What if I enter an invalid value?
The tool will show a warning that the value doesn't look valid rather than silently displaying an incorrect date.