Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


date conversion

chris_77chris_77 Member Posts: 1
i am using the following date conversion on sql server v.8

SELECT * FROM weeklyMovements WHERE (weekCommencing = CONVERT(datetime, '" & weekStartDay & "'))

(weekCommencing being a smalldatetime field in the database
and weekStartDay being a variable holding a date)
However, I have just transfered the database to sql server v.7
and the date conversion no longer works.

Any suggestions would be appreciated


  • Justin BibJustin Bib USAMember Posts: 0

    ___ ( ) free video tutorials and ebooks about || R, Visual Basic .NET, C++, Delphi, Objective-C, JavaScript, MATLAB, Assembly, PL/SQL, Scratch, C, Python, C#, Visual Basic, Go, Ruby, PHP, Java, Swift, Perl Transact-SQL, SAS, Apex, Erlang, Fortran, ABAP, Bash, Hack, Lua, FoxPro, Ada, Clojure, D, Logo, COBOL, Julia, Prolog, Dart, F#, Crystal, Lisp, Awk, VBScript, ML, LabVIEW, Rust, Scala, Kotlin, Scheme, Alice || _________

Sign In or Register to comment.