AspenUtil - SQL 'IN' converter & more

CRX ID
gofaemdainmnfjcipjgbmfaidnlemiea
Status
Live on Store
Description from extension meta

Simple converter for anyone doing SQL 'IN' queries.

Image from store
AspenUtil - SQL 'IN' converter & more
Description from store

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.

Latest reviews

Chiv Heng 2025-04-29

Hands down, most useful extension in my workflow

Amanda Cenerizio 2025-04-10

Use this all the time and I tell other people about it too. It's very useful and saves so much time

CHEERASAK KWUANTHONG (Gee) 2023-03-16

good job

CHEERASAK KWUANTHONG (Gee) 2023-03-16

good job

Andy Moore 2018-11-13

VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!

Andy Moore 2018-11-13

VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!

Andrew Bullock 2017-10-18

What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.

Andrew Bullock 2017-10-18

What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.

Mark Glass 2016-04-12

Most useful chrome extension I have. I use this everyday.

Mark Glass 2016-04-12

Most useful chrome extension I have. I use this everyday.

Tim Reed 2016-03-28

Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.

Tim Reed 2016-03-28

Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.

Bryce Avery 2015-08-28

Useful for other tools then just Aspen Student Information System. Will work whenever a comma delimited list is need for example in SQL when using in statements in where clause.

Bryce Avery 2015-08-28

Useful for other tools then just Aspen Student Information System. Will work whenever a comma delimited list is need for example in SQL when using in statements in where clause.

Statistics

Installs
4,000
Market
Chrome Web Store
Category
Rating
4.83 (12 votes)
Last update
2024-09-22
Version 3.0
Languages