AspenUtil - SQL 'IN' converter & more
Item media 3 screenshot
Item media 4 screenshot
Item media 1 screenshot
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot
Item media 1 screenshot
Item media 2 screenshot
Item media 1 screenshot
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot

Overview

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.

4.8 out of 59 ratings

Google doesn't verify reviews. Learn more about results and reviews.

Review's profile picture

CHEERASAK KWUANTHONG (Gee)Mar 16, 2023

good job

Review's profile picture

Andy MooreNov 13, 2018

VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!

1 person found this review to be helpful
Review's profile picture

Andrew BullockOct 18, 2017

What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.

1 person found this review to be helpful

Details

  • Version
    1.9
  • Updated
    October 2, 2018
  • Offered by
    Stephen Lyle
  • Size
    39.56KiB
  • Languages
    English
  • Developer
    Email
    stephen.lyle@gmail.com
  • Non-trader
    This developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.

Privacy

The developer has not provided any information about the collection or usage of your data.

Support

Google apps