AspenUtil - SQL 'IN' converter & more

Download extension

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.