首页 开发者工具 AspenUtil - SQL 'IN' converter & more

AspenUtil - SQL 'IN' converter & more

用户数 : 425 分类 : 开发者工具 扩展大小 : 38.82KiB 最后更新时间 : 2018-10-02 版本 : 1.9
prev extension banner next extension banner
                            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.
                        
查看更多
下载 如何离线安装? Chrome store

分享

全部评论

    展开更多评论

    错误提示保存失败
    成功提示保存成功
    close
    qr-code

    为打击盗链困扰,本站已启用公众号验证
    微信扫码关注上方公众号,回复“插件”二字获得验证码,验证码5分钟内全站有效。

    正在验证
    验证成功
    下载遇到问题?请添加QQ群:398095333
    close
    qr-code

    为打击盗链困扰,本站已启用公众号验证
    微信扫码关注上方公众号,回复“脚本”二字获得验证码,验证码5分钟内全站有效。

    正在验证
    验证成功