Results 1 to 4 of 4

Thread: date constant in sql 7 stored procs

  1. Oct 10th, 2002, 10:29 AM #1
    wernerh
    wernerh is offline

    Thread Starter
    Addicted Member wernerh's Avatar
    Join Date
    Sep 2000
    Posts
    170

    date constant in sql 7 stored procs

    Hi all,

    can anyone tell me what is the date constant in sql server 7, I've used getdate and date but is not recognized by sql.

    'code

    if getdate > '10/05/2002'
    Reply With Quote Reply With Quote
  2. Oct 10th, 2002, 10:39 AM #2
    Blobby
    Blobby is offline
    Frenzied Member Blobby's Avatar
    Join Date
    Oct 2001
    Location
    England
    Posts
    1,512
    Isnt it getdate()
    ?
    There are 3 types of people in this world.........those that can count, and those that can't.

    Blobby
    Reply With Quote Reply With Quote
  3. Oct 10th, 2002, 10:39 AM #3
    techyspecy
    techyspecy is offline
    Let me in .. techyspecy's Avatar
    Join Date
    Aug 2002
    Location
    Back to VBF.
    Posts
    2,456
    Originally posted by Blobby
    Isnt it getdate()
    ?
    that's right.
    Reply With Quote Reply With Quote
  4. Oct 10th, 2002, 10:43 AM #4
    Wokawidget
    Wokawidget is offline
    Super Moderator Wokawidget's Avatar
    Join Date
    Nov 2001
    Location
    Headingly Occupation: Classified
    Posts
    9,632
    Code:
    GetDate
    ...Causes an error...
    Code:
    GetDate()
    ...Doesn't

    Stupid SQL Server...

    Also, be careful, '10/05/2002' could be 5th Oct or 10th May, depending on what format SQL Server is set to
    I always use dates in '10 May 2002' format...just to be sure

    Woka
    My .NET Tutorials:
    • Silverlight Enabled WebPart in WSS

    My VB.NET Code Examples:
    • Create IIS Virtual Directory • Validate Login Against Active Directory • Automatically retrieve Identity field value from inserted DataRow using SQL Server and ADO.NET

    My ASP.NET Code Examples:
    • Login To Website (Forms Authentication) • Login To Website (Custom Authentication)

    My VB6 Code Projects:
    • Multithreading In VB6 • Custom Tooltips • Multi Language Support • Item Selector Control • Annimated Systray Icon • Simple Effective Graph Control • Download From Web • LiveUpdate, download application updates from the web automatically • Systray Notification Messages • Skin A Form • API Timer • Badger Messenger, an MSN clone that uses the MSN Network • Wokawidgets VB6 Component Suite
    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