AspenUtil - SQL 'IN' converter & more

#4.78 / 9 rate

AspenUtil - SQL 'IN' converter & more

3,000 users

2018-10-02

Stephen Lyle

Extension Information

5 star
83%
4 star
17%
3 star
0%
2 star
0%
1 star
0%

Supported Languages

Description

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

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.

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.

Reviews

CHEERASAK KWUANTHONG (Gee)
CHEERASAK KWUANTHONG (Gee)

good job

Andy Moore
Andy Moore

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

Andrew Bullock
Andrew Bullock

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

Similar extensions

Search API Query String Parser
Search API Query String Parser

Sam Larison

RE:DOM dev tools
RE:DOM dev tools

https://redom.js.org

Scripter debugger extension
Scripter debugger extension

roi.benhaim

JSON2Class
JSON2Class

yozian

Utilspoint
Utilspoint

https://www.utilspoint.com

Atma.js DevTool
Atma.js DevTool

https://atmajs.com

SQL Viewer
SQL Viewer

Ravikiran Janardhana

SQL Format
SQL Format

omangi

Timestamp converter
Timestamp converter

ilia___makarov

SQL Formatter
SQL Formatter

noah.yonack.cws

BigQuery Mate
BigQuery Mate

Mikhail Berlyant

stringG
stringG

https://ivanova-irina.blogspot.com