Results 1 to 4 of 4

Thread: [MySQL] Equivalent to MSSQL?[RESOLVED]

Threaded View

  1. Jan 31st, 2005, 09:56 AM #1
    john tindell
    john tindell is offline

    Thread Starter
    <?="Moderator"?> john tindell's Avatar
    Join Date
    Jan 2002
    Location
    Brighton, UK
    Posts
    1,099

    Resolved [MySQL] Equivalent to MSSQL?[RESOLVED]

    Hey in MSSQL when i want to check a column to see if its older than five minutes i do

    Code:
      DATEDIFF(minute,time_column,GETDATE()) <= 5
    Is there an an equivalent in MySQL? or do i have to create the date in PHP and compare that value to the one in my DB?

    Thanks
    Last edited by john tindell; Jan 31st, 2005 at 11:38 AM.
    [MindlessAnt.co.uk] [MSDN] [Paging Records With MS SQL] [Virtual CD-ROM Drive From Images] [WorldOverRide.co.uk] [Create PDF's using pure PHP] [PHP.net Search Bars]
    [PHP: Check Password Strength][PHP: BB Code] [PHP: Date Select]

    If you Question has been answered please mark the thread as [RESOLVED]
    Mediocre post? Please Rate it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width