CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. February 3rd, 2010, 09:12 AM #1
    leeshadmi's Avatar
    leeshadmi
    leeshadmi is offline Member
    Join Date
    Sep 2002
    Location
    Israel
    Posts
    396

    SQL how to search dates on strings fields?

    Hi,
    Lets say i have strings fields in my table and i they will represent dates.
    How can i search these dates so i can use the between and such search settings?
    Thanks
    Reply With Quote Reply With Quote
  2. February 4th, 2010, 02:49 AM #2
    Alsvha
    Alsvha is offline Member +
    Join Date
    Feb 2005
    Location
    Denmark
    Posts
    742

    Re: SQL how to search dates on strings fields?

    You can cast strings to dates:
    http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

    Then you can use date operations and comparisons on them.
    EXEC(@sql) - My blog about SQL Server and related topics.
    Svelmoe.dk - The everyday thoughts of a developer
    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

Featured