AspenUtil - SQL 'IN' converter & more
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.