AspenUtil – SQL ‘IN’ converter & more下载 - 插件下载

基本信息

更新日期:: 2020-08-02
包名:: gofaemdainmnfjcipjgbmfaidnlemiea
版本:: 1.9
大小:: 38.82KiB
类型:: Chrome
平台:: Chrome

评分:: 8
发布日期:: 2018-10-02
价格:: 免费
开发者:: Stephen Lyle

AspenUtil – SQL ‘IN’ converter & more插件截图

AspenUtil – SQL ‘IN’ converter & more插件简介

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.