Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Unanswered: Application need Date without Time

    Hello,

    We are managing industry standard application for solvent business need and it is working fine as per requirement but after replication we got some problem with date type data.

    We have stored date data through application in dd/mm/yy format only, we didn't used time data so it is truncated in overall application but after implementation for replication (Merge Model) from multiple location some date field automatically get time with date value, so some time application not retrieving data from database owing to stored time with date.

    How I can resolve this issue I didn't get any solution in short way.

    Thanks in advance to every particapetience.

    R.Mall

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You do know that datetime data always stores both. right?

    If no time is supplied the default time is 0, or midnight.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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