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. Thats 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 Chrome extension download link you can download and install Chrome Browser.
auto generate class code by JSON data!
View SQL files/content formatted in the browser
A chrome plugin to format your SQL code
Development Tool to develop, inspect and debug Atma.js Components
This extension debugs the scripter blocks and load proccess
Generate string of specified length or calculate the length of specified string
Companion tool for Google BigQuery UI used by myself and my peers at Viant Inc. Adds some extra functionality to BQ Native UI
View and edit long URL search query string with relative ease