CRX id
gofaemdainmnfjcipjgbmfaidnlemiea
gofaemdainmnfjcipjgbmfaidnlemiea
Description from extension meta
Simple converter for anyone doing SQL 'IN' queries.
Image from store
Description from store
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.
Latest reviews
- (2023-03-16) CHEERASAK KWUANTHONG (Gee): good job
- (2018-11-13) Andy Moore: VERY useful extension for sql queries. Does what it promises, does it well, and saves a ton of time!
- (2017-10-18) Andrew Bullock: What did we do before this was out!?!? Works perfectly and has sped up many of my procedures.
- (2016-04-12) Mark Glass: Most useful chrome extension I have. I use this everyday.
- (2016-03-28) Tim Reed: Simple, fast and easy way to parse values into SQL-ready strings. No muss, no fuss.
- (2015-08-28) Bryce Avery: Useful for other tools then just Aspen Student Information System. Will work whenever a comma delimited list is need for example in SQL when using in statements in where clause.
Statistics
Installs
4,000
history
Category
Rating
4.7778 (9 votes)
Last update / version
2024-09-22 / 3.0
Listing languages
en