Item logo image for AspenUtil - SQL 'IN' converter & more

AspenUtil - SQL 'IN' converter & more

Featured
4.8(

9 ratings

)
Item media 4 screenshot
Item media 5 screenshot
Item media 1 screenshot
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot
Item media 5 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
Item media 5 screenshot

Overview

Simple converter for anyone 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. Step 3: If you don't want the single quotes around each value, there's a button for that. 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.

Details

  • Version
    3.0
  • Updated
    September 22, 2024
  • Offered by
    Stephen Lyle
  • Size
    40.59KiB
  • 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 disclosed that it will not collect or use your data.

This developer declares that your data is

  • Not being sold to third parties, outside of the approved use cases
  • Not being used or transferred for purposes that are unrelated to the item's core functionality
  • Not being used or transferred to determine creditworthiness or for lending purposes

Support

Related

SQL Format

4.6(15)

A chrome plugin to format your SQL code

Saverd Recipe Clipper

5.0(1)

Save recipes from hundreds of recipe sites right to your Saverd recipe box.

Timestamp converter

5.0(1)

Extension for convert timestamp to date and date to timestamp

SQL Formatter

5.0(3)

Formats your SQL for easier reading, code review, and debugging.

Search API Query String Parser

5.0(3)

View and edit long URL search query string with relative ease

RE:DOM dev tools

5.0(1)

RE:DOM dev tools for Chrome

Tanuki Utilities

5.0(1)

Provide useful utilities for GitLab users.

Scripter debugger extension

5.0(2)

This extension debugs the scripter blocks and load proccess

JSON2Class

5.0(3)

auto generate class code by JSON data!

Utilspoint

5.0(2)

…more than 1000 utilities & tools !

Atma.js DevTool

0.0(0)

Development Tool to develop, inspect and debug Atma.js Components

SQL Viewer

3.8(5)

View SQL files/content formatted in the browser

SQL Format

4.6(15)

A chrome plugin to format your SQL code

Saverd Recipe Clipper

5.0(1)

Save recipes from hundreds of recipe sites right to your Saverd recipe box.

Timestamp converter

5.0(1)

Extension for convert timestamp to date and date to timestamp

SQL Formatter

5.0(3)

Formats your SQL for easier reading, code review, and debugging.

Search API Query String Parser

5.0(3)

View and edit long URL search query string with relative ease

RE:DOM dev tools

5.0(1)

RE:DOM dev tools for Chrome

Tanuki Utilities

5.0(1)

Provide useful utilities for GitLab users.

Scripter debugger extension

5.0(2)

This extension debugs the scripter blocks and load proccess

Google apps