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

    Unanswered: SQL Server 2000 SP3 installed - Problem with Convert() function

    I am facing a problem with Convert function in SQL server 2000 with sp3 installed , Japanese version

    In sql server 2000 (sp1 installed) Japanese version, the convert(datetime,,111) gives me date in the format yyyy-mm-dd hh:min:sec

    But in sql server 2000 (sp3 instaled) Japanese version, the convert(datetime, ,111) gives me date in the format yyyy-mm-dd.

    I need the hh:min:sec to do an exact date comparison.

    The problem is solved if I use Convert(datetime,,120).

    Any pointers on the root cause of why the problem occurs with convert() function once sp3 is installed?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    According to the documentation for Convert(), the style argument is only used when converting to the character format. If you're converting to char, then please post the actual code you are using. If you aren't, then you have a very different problem and you need to figure out what is going wrong before we can help you.

    In either case, you'd be better off if you posted the actual code you are using that causes the problem, instead of typing something that you think demonstrates the problem.


Posting Permissions

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