AspenUtil - SQL 'IN' converter & more chrome extension

Version: 1.9
AspenUtil - SQL 'IN' converter & more
Simple converter for Aspen power users, and anyone else doing SQL 'IN' queries.
4.78 Based on 9 user rates

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

AspenUtil - SQL 'IN' converter & more is a sql extension for chrome. it's a free extension , it has 2,000+ active users since released its first version, it earns an average rating of 4.78 from 9 rated user, last update is 2274 days ago.


What’s new in version 1.9?

                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.            

How to install AspenUtil - SQL 'IN' converter & more?

You could download the latest version crx file or older version files and install it.


Preview of AspenUtil - SQL 'IN' converter & more


Technical Features:

  • Latest Version: 1.9
  • Requirements: Windows Chrome, Mac Chrome
  • License: Free
  • Latest update: Tuesday, October 2nd, 2018
  • Author: Stephen Lyle

AspenUtil - SQL 'IN' converter & more Available languages:

English.


FAQ


Reviews of aspenutil - sql 'in' converter & more:


Andy Moore November 13th, 2018
Andy Moore

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


Andrew Bullock October 18th, 2017
Andrew Bullock

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


Mark Glass April 12th, 2016
Mark Glass

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

Read more review & comments of aspenutil - sql 'in' converter & more