WinSQL » Knowledge base

Document information

Document ID:824
Subject:What functions does WinSQL support?
Creation date:7/29/09 4:59 PM
Last modified on:7/29/09 4:59 PM


WinSQL supports every function that is supported by your back-end database. In addition, it also supports ODBC escape functions.

Example: Consider the following table:

FirstName CHAR(30)
LastName CHAR(30)
HireDate DATE

You need list all individuals who were hired on a Friday. The following query will return the desired result.

select FirstName, LastName
from employees.txt
where {fn DAYOFWEEK{HireDate)} = 6

For a complete list of supported functions, please refer to WinSQL User's Guide.

User comments

Posted by Gosa Shiferaw on 3/17/11 2:03 PM

what database question and answer these question?

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by