<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>

[{'answer_id': 56310, 'author': 'cmsherratt', 'author_id': 3512, 'author_profile': 'https://Stackoverflow.com/users/3512', 'pm_score': 5, 'selected': False, 'text': "<p>Use the convert function, for example:</p>\n\n<pre><code>select * from data \nwhere dateVal &lt; convert(datetime, '01/01/2008', 103)\n</code></pre>\n\n<p>Where the convert style (103) determines the date format to use.</p>\n"}, {'answer_id': 74525, 'author': 'Jose B.', 'author_id': 5413, 'author_profile': 'https://Stackoverflow.com/users/5413', 'pm_score': 2, 'selected': False, 'text': "<p>Several ways to accomplish that but be aware that your DB <strong>date_format option</strong> &amp; <strong>date_order option</strong> settings could affect the incoming format:</p>\n\n<pre><code>Select \n   cast('2008-09-16' as date)\n   convert(date,'16/09/2008',103)\n   date('2008-09-16')\nfrom dummy;\n</code></pre>\n"}, {'answer_id': 826535, 'author': 'Edwin', 'author_id': 99363, 'author_profile': 'https://Stackoverflow.com/users/99363', 'pm_score': 3, 'selected': False, 'text': '<p>Here\'s a good reference on the different formatting you can use with regard to the date:</p>\n\n<p><a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/Convert.htm" rel="nofollow noreferrer">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/Convert.htm</a></p>\n'}, {'answer_id': 9204851, 'author': 'Jackie', 'author_id': 410289, 'author_profile': 'https://Stackoverflow.com/users/410289', 'pm_score': -1, 'selected': False, 'text': "<p>102 is the rule of thumb,\nconvert (varchar, creat_tms, 102) > '2011'</p>\n"}]
['https://Stackoverflow.com/questions/56303', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/3512/']