1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Date comparison with C# and SQL Server 2005

Discussion in 'C#' started by rhaazy, Aug 3, 2007.

  1. rhaazy

    rhaazy New Member

    Joined:
    Jul 6, 2007
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    0
    In C# code I want to do a date comparison against a column is the database.

    Something like:

    select someColumn from someTable
    where CurrentDate-someDate > ElapsedTimeColumn

    I want to get the currentdate in C# and run a query from my application.

    How do i get the format of:

    mm/dd/yyyy hh:ss:mm AM/PM

    Thanks.
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    DateTime class located in the System namespace would help you.

    Code:
    System.DateTime.Now
    
    System.DateTime.Today
     
  3. rhaazy

    rhaazy New Member

    Joined:
    Jul 6, 2007
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    0
    Any idea what system.datetime.now would throw an sql exception error?
    The format it returns is identical to the format of my sql column....

    This isn't an issue, and I decided to just use the sql function getdate to do what I needed, but I do no understand why this would throw an error. Perhaps it is a simple formatting error on my part when concatenating the strings, but maybe someone had a similiar problem before. thanks.
     
  4. SNK111

    SNK111 New Member

    Joined:
    Apr 10, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    This scenario usually arises when the data is not 'received' properly from the database.

    Check this link ( shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html ) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries, calling stored procedures, pass parameters etc.

    Shahriar Nour Khondokar: shahriarnk.com/
     

Share This Page