<p>I need to specify a date value in a sybase where clause. For example:</p>

<pre><code>select * 
from data
where dateVal &lt; [THE DATE]
</code></pre>

Use the convert function, for example:
```
```
select * from data 
where dateVal < convert(datetime, '01/01/2008', 103)
```
```
Where the convert style (103) determines the date format to use.