Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find DOW in SQL Server?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01687856
Message ID:
01687858
Views:
28
>Hi,
>
>I want to specify in the SQL Select that Day of the Week in Monday. I know that in VFP it would be the function DOW().
>That is, in VFP I would use
>
>where DOW(date_field) = 2
>
>What function could I use in SQL Server?
>
>TIA
SET DATEFIRST = 1
Check my answer to your previous question.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform