| Forum: ASP Classic |
Thema:
Re: to_date ( ORACLE) SQL Server |
Von:
Rainer Jeschor (
17.05.2004 13:13) |
Hi,
the cast (or better the convert) in MSSQL should look like this:
...
(Convert(Char(8), LTRIM(STR(VALID_FROM_YEAR)) + " &_
" RIGHT('0' + LTRIM(STR(VALID_FROM_MONTH)),2) + " &_
" RIGHT('0' + LTRIM(STR(VALID_FROM_DAY)),2)) <= Convert(Char(8), GetDate(),112)) AND
...
This code part makes a comparisson if the date in the database (which is in three different fields) is lower or equal than the date of today.
HTH,
Rainer Jeschor
MCSD, MCDBA
Antworten
Vorsicht bei der Eingabe: Die Zeichen ' oder -- sind nicht erlaubt!
