Simple converter for anyone doing SQL 'IN' queries.

Latest Version

Version
3.0
Update
September 21, 2024
Size
40.59KiB
Developer
Category
Users
4,000+
Rating
4.77778 ★
Manifest Version
3
Web Store Status
Languages Support
English
See more
Permissions
See more

AspenUtil - SQL 'IN' converter & more Extension

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.
Read more

Source Manifest.json

{ "background": { "service_worker": "service_worker.js", "persistent": false }, "content_security_policy": {}, "manifest_version": 3, "update_url": "https://clients2.google.com/service/update2/crx", "name": "AspenUtil - SQL 'IN' converter & more", "action": { "default_popup": "index.html", "default_icon": { "128": "assets/icon_128.png", "48": "assets/icon_48.png", "32": "assets/icon_32.png", "19": "assets/icon_19.png" }, "default_title": "AspenUtil-SQL_'IN'_converter_and_more" }, "description": "Simple converter for anyone doing SQL 'IN' queries.", "version": "3.0", "short_name": "SQL 'IN' Converter"}
Read more

Similar Extensions

icon

Search API Query String Parser Extension · Developer Tools 4,000+ 3 ★ 251KiB

icon

RE:DOM dev tools Extension · Developer Tools 4,000+ 1 ★ 207KiB

icon

Tanuki Utilities Extension · Developer Tools 4,000+ 1 ★ 25.43KiB

icon

Scripter debugger extension Extension · Developer Tools 4,000+ 2 ★ 1.04MiB

icon

JSON2Class Extension · Developer Tools 4,000+ 3 ★ 95.44KiB

icon

Utilspoint Extension · Developer Tools 4,000+ 2 ★ 33.33KiB

icon

Atma.js DevTool Extension · Developer Tools 4,000+ 0 ★ 201KiB

icon

SQL Viewer Extension · Developer Tools 4,000+ 5 ★ 232KiB

icon

SQL Format Extension · Developer Tools 4,000+ 15 ★ 110KiB

icon

Saverd Recipe Clipper Extension · Productivity 4,000+ 1 ★ 48.51KiB

icon

Timestamp converter Extension · Developer Tools 4,000+ 1 ★ 69.37KiB

icon

SQL Formatter Extension · Developer Tools 4,000+ 3 ★ 102KiB

icon

stringG Extension · Developer Tools 4,000+ 0 ★ 11.65KiB

icon

Timestamp Converter Extension · Productivity 4,000+ 2 ★ 65.02KiB

icon

sqanything Extension · Developer Tools 4,000+ 5 ★ 2.15MiB

icon

SQLDelimiter Extension · Developer Tools 4,000+ 17 ★ 20.88KiB

icon

BigQuery Mate Extension · Productivity 4,000+ 23 ★ 206KiB

icon

captureCalls Extension · Developer Tools 4,000+ 1 ★ 9.63KiB

icon

Colibri: modify Ajax response Extension · Developer Tools 4,000+ 2 ★ 220KiB

icon

server-spy Extension · Developer Tools 4,000+ 3 ★ 59.55KiB

icon

CoffeeScript Console 3 Extension · Developer Tools 4,000+ 0 ★ 438KiB

icon

DOM-JSON Tree Matcher Extension · Developer Tools 4,000+ 0 ★ 18.58KiB

icon

Not my department Extension · Developer Tools 4,000+ 1 ★ 1.44MiB

icon

Check for .git directory existence Extension · Developer Tools 4,000+ 0 ★ 49.98KiB

User reviews

icon

CHEERASAK KWUANTHONG (Gee) (ID: 000000b5965dd435) Voted 5 ★ - Updated 03/16/2023 good job

icon

Andy Moore (ID: 000000601f703e94) Voted 5 ★ - Updated 11/13/2018 VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!

icon

Andrew Bullock (ID: 000000c1e4bff63d) Voted 5 ★ - Updated 10/18/2017 What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.

icon

Mark Glass (ID: 00000069a3f64705) Voted 5 ★ - Updated 04/12/2016 Most useful chrome extension I have. I use this everyday.

icon

Tim Reed (ID: 000000d7da9f2e36) Voted 5 ★ - Updated 03/28/2016 Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.