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.
You can Follow the below Step By Step procedure to install the AspenUtil - SQL 'IN' converter & more Chrome Extension to your Chrome Web browser.
It is the AspenUtil - SQL 'IN' converter & more google chrome extension download link you can download and install google chrome Browser.
Tags: Enter Date , Milliseconds Automatically Copied , Timestamp Conversions , Simple Converter , Aspen Power Users , Query , Convert Series , Enter Timestamp , Single Quotes , Unix Time , Sql , Sql Query Editor , Comma Delimited ,