AspenUtil - SQL 'IN' converter & more

Simple converter for Aspen power users, and anyone else doing SQL 'IN' queries.

What is AspenUtil - SQL 'IN' converter & more?

The 'AspenUtil - SQL 'IN' converter & more' Chrome extension is a versatile tool primarily for Aspen power users. It offers a solution to facilitate SQL 'IN' queries. It prepares a list of values to be used with a SQL 'IN' query by converting these values to a comma delimited format with single quotes around each value. Additionally, this extension can convert dates to timestamps (in Unix time/epoch presented in milliseconds) and vice-versa. This tool automates these conversions and saves time, eliminating the need for manual data modification.

Download

Stats

By: Stephen Lyle

View on Chrome Web Store

Users: 3,000+

Rating: 4.78 (9)

Version: 1.9 (Last updated: 2018-10-02)

Creation date: 2018-10-02

Risk impact: Very low risk impact

Risk likelihood: Very low risk likelihood

Manifest version: 2

Size: 40.51K

Email: st*****@gmail.com

Stats date:

Chrome-Stats Rank

# 17739 ▼ 42

Other rankings

#747 in Developer Tools ▼ 1 #82 in convert keyword 53 ▲ 18 #101 in query keyword 6 #207 in value keyword 8 ▲ 8 #255 in date keyword 14 ▼ 15

Other platforms

Not available on Firefox

Not available on Edge

Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.

Summary

Analyze keywords

This utility has three features:

Prepares a list of values to be used with a SQL "IN" query.
Converts a date to a timestamp (Unix time or epoch...in milliseconds)
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.

That's it! Your string will be automatically converted and copied to your clipboard!