Simple converter for anyone doing SQL 'IN' queries.
Users
4,000
0 in 30 days
Rating
4.8 / 5
unchanged in 30 days
Ratings
11
0 in 30 days
Store rank
#15K
#13K among extensions
Version
3.0
updated 22 Sep 2024
Users
monthly, 3 years
Latest, 15 Oct 2026:4,000 usersMove the mouse over the chart for any month
Ratings count
monthly, 3 years
Latest, 15 Oct 2026:11 ratingsMove the mouse over the chart for any month
The Chrome Web Store rounds user counts down to the leading digit, so the user line moves in steps. The ratings count is exact and is the better signal of real adoption.
About AspenUtil - SQL 'IN' converter & more
This utility has three features:
1) Prepares a list of values to be used with a SQL "IN" query.
2) Converts a date to a timestamp (Unix time or epoch...in milliseconds)
3) Converts a timestamp (in milliseconds) to a date
For SQL 'IN' Queries:
=====================
This utility can be used in any situation where you need to convert a series of values to being comma delimited with single quotes around each value.
INSTRUCTIONS:
Step 1: Take a list of values (for example, copied from a spreadsheet or SQL Query editor) and paste it into the textarea of this extension.
Step 2: Click the "Convert" button.
Step 3: If you don't want the single quotes around each value, there's a button for that.
That's it! Your string will be automatically converted and copied to your clipboard!
For Date to Timestamp Conversions:
==================================
Enter a date in the format of your choosing (5/1/2016, or May 1, 2016) and click the "Convert" button. You will get back the timestamp (Unix time or epoch) in milliseconds, automatically copied to your clipboard.
Similarly, if you enter a timestamp in milliseconds, it will give you the date.