Simple converter for anyone doing SQL 'IN' queries.
AspenUtil - SQL 'IN' converter & more Extension
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.
Source Manifest.json
Similar Extensions
Search API Query String Parser 4,000+ 3 ★ 251KiB
RE:DOM dev tools 4,000+ 1 ★ 207KiB
Tanuki Utilities 4,000+ 1 ★ 25.43KiB
Scripter debugger extension 4,000+ 2 ★ 1.04MiB
JSON2Class 4,000+ 3 ★ 95.44KiB
Utilspoint 4,000+ 2 ★ 33.33KiB
Atma.js DevTool 4,000+ 0 ★ 201KiB
SQL Viewer 4,000+ 5 ★ 232KiB
SQL Format 4,000+ 15 ★ 110KiB
Saverd Recipe Clipper 4,000+ 1 ★ 48.51KiB
Timestamp converter 4,000+ 1 ★ 69.37KiB
SQL Formatter 4,000+ 3 ★ 102KiB
stringG 4,000+ 0 ★ 11.65KiB
Timestamp Converter 4,000+ 2 ★ 65.02KiB
sqanything 4,000+ 5 ★ 2.15MiB
SQLDelimiter 4,000+ 17 ★ 20.88KiB
BigQuery Mate 4,000+ 23 ★ 206KiB
captureCalls 4,000+ 1 ★ 9.63KiB
Colibri: modify Ajax response 4,000+ 2 ★ 220KiB
server-spy 4,000+ 3 ★ 59.55KiB
CoffeeScript Console 3 4,000+ 0 ★ 438KiB
DOM-JSON Tree Matcher 4,000+ 0 ★ 18.58KiB
Not my department 4,000+ 1 ★ 1.44MiB
Check for .git directory existence 4,000+ 0 ★ 49.98KiB
User reviews
CHEERASAK KWUANTHONG (Gee) (ID: 000000b5965dd435) Voted 5 ★ - Updated 03/16/2023
Andy Moore (ID: 000000601f703e94) Voted 5 ★ - Updated 11/13/2018
Andrew Bullock (ID: 000000c1e4bff63d) Voted 5 ★ - Updated 10/18/2017
Mark Glass (ID: 00000069a3f64705) Voted 5 ★ - Updated 04/12/2016
Tim Reed (ID: 000000d7da9f2e36) Voted 5 ★ - Updated 03/28/2016