AspenUtil - SQL 'IN' converter & more
Overview
AspenUtil - SQL 'IN' converter & more is a Chrome extension developed by Stephen Lyle.
According to the data from Chrome web store, current version of AspenUtil - SQL 'IN' converter & more is 1.9, updated on 2018-10-02.
2,000+ users have installed this extension.
9 users have rated this extension with an average rating of .
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.
AspenUtil - SQL 'IN' converter & more Alternatives
Latest Reviews
See More
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!?!? |
Mark Glass
2016-04-12
Most useful chrome extension I have. |
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. |