AspenUtil - SQL 'IN' converter & more
Extension Actions
Simple converter for anyone 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.
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
- Hands down, most useful extension in my workflow
- Amanda Cenerizio
- 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)
- good job
- CHEERASAK KWUANTHONG (Gee)
- good job
- Andy Moore
- VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!
- Andy Moore
- VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!
- Andrew Bullock
- What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.
- Andrew Bullock
- What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.
- Mark Glass
- Most useful chrome extension I have. I use this everyday.
- Mark Glass
- Most useful chrome extension I have. I use this everyday.
- Tim Reed
- Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.
- Tim Reed
- Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.
- Bryce Avery
- 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
- 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.