The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Software Testing >> Functional Testing

Pages: 1
alli
Newbie


Reged: 04/15/08
Posts: 6
MySQL compare date in bigint with specific date?
      #718080 - 10/15/12 11:38 PM

Hello,

I have a date/time field stored as BIGINT in the database. I need to retrieve records where the date in the database is older than a specific date. The returned records should include all columns.

Could some one please give me advice?

Thanks.


Post Extras: Print Post   Remind Me!   Notify Moderator  
alli
Newbie


Reged: 04/15/08
Posts: 6
Re: MySQL compare date in bigint with specific date? [Re: alli]
      #718083 - 10/15/12 11:57 PM

I tried this and it returned as I expected.
Is there any more simple way?

select * from test.users where (CONCAT(FROM_UNIXTIME(LEFT(created, LENGTH(created) - 3)))) >= '2012-10-09 00:00:00';


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 19 anonymous users are browsing this forum.

Moderator:  blueinatl, AJ, Jeanj, corklad, martinh, brentpaine 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 2160

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5