CRX id
gofaemdainmnfjcipjgbmfaidnlemiea
gofaemdainmnfjcipjgbmfaidnlemiea
Description from extension meta
Simple converter for Aspen power users, and anyone else 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.
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.
Latest issues
- (2020-03-24, v:1.9) Tham Tran: Does it still work?
Hello. Does this extension still work? I put in : 1 2 and I get back: 978411600000 Thanks - (2020-02-12, v:1.9) Andy Moore: Kudos
No real suggestion other than to keep this utility alive. I use this at least once a week! If there were a way to donate toward this project, I would! - (2016-06-08, v:1.5) Bryce Avery: List Issue
This list: Boston Parochial Mass. Parochial, Boston Resident Mass. Public, Boston Resident Mass. Private (Non-Parochial), Boston Resident Boston Private (Non-Parochial) Work GED Home(*KINDERGARTEN ONLY) Adult Diploma Program Discharged to Charter School Moved - No Forwarding Address Converted to: 'Boston','Parochial','Mass.','Parochial,','Boston','Resident','Mass.','Public,','Boston','Resident','Mass.','Private','(Non-Parochial),','Boston','Resident','Boston','Private','(Non-Parochial)','Work','GED','Home(*KINDERGARTEN','ONLY)','Adult','Diploma','Program','Discharged','to','Charter','School','Moved','-','No','Forwarding','Address' It would be nice if it was possible to us line breaks for parsing only instead of line breaks and blank space.
Statistics
Installs
3,487
history
Category
Rating
4.7778 (9 votes)
Last update / version
2018-10-02 / 1.9
Listing languages
en