Movatterモバイル変換


[0]ホーム

URL:


Skip to content
DEV Community
Log in Create account

DEV Community

Mukit, Ataul
Mukit, Ataul

Posted on

     

MYSQL Query With Timestamp Long Values

function MySQLTimeStampCompatibleString(timestamp){    return new Date(timestamp).toISOString().substring(0, 19).replace('T', ' ');}   function queryWithTimestampLongValues(fromTime, toTime) {    var query = "";        if(fromTime && toTime){              query += 'SELECT * FROM user_info WHERE                    user_info.created_at > TIMESTAMP("' +                        MySQLTimeStampCompatibleString(fromTime) + '") AND                    user_info.created_at < TIMESTAMP("' +                    MySQLTimeStampCompatibleString(toTime) +  '")';        }    return query;}

Top comments(0)

Subscribe
pic
Create template

Templates let you quickly answer FAQs or store snippets for re-use.

Dismiss

Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment'spermalink.

For further actions, you may consider blocking this person and/orreporting abuse

I consider myself as an enthusiast in learning new things everyday, about our history and future as well as the present. My interests: Ancient History, Comparative Religion, Science and Tech, C++
  • Location
    Dhaka, Bangladesh
  • Joined

Trending onDEV CommunityHot

DEV Community

We're a place where coders share, stay up-to-date and grow their careers.

Log in Create account

[8]ページ先頭

©2009-2025 Movatter.jp