<div>
Hi<br />
<br />
try this<br />
<br />
<br />
declare @today datetime<br />
select @today=getdate()<br />
select &nbsp;convert(char(8), dateadd(dd, 1-datepart(day,@today), @today), 112)
</div>


Hi

try this


declare @today datetime
select @today=getdate()
select  convert(char(8), dateadd(dd, 1-datepart(day,@today), @today), 112)

<div>
This more customized for your need<br />
<br />
declare @today datetime<br />
select @today=getdate()<br />
select &nbsp;convert(datetime, convert(char(8), dateadd(dd, 1-datepart(day,@today), @today), 112))
</div>


This more customized for your need

declare @today datetime
select @today=getdate()
select  convert(datetime, convert(char(8), dateadd(dd, 1-datepart(day,@today), @today), 112))

<div>
This is how you can do that using MS SQL Server, so I assume something similar in Sybase:<br />
<br />
Select YourDate - Day(YourDate) + 1<br />
From &nbsp; YourTableName
</div>


This is how you can do that using MS SQL Server, so I assume something similar in Sybase:

Select YourDate - Day(YourDate) + 1
From   YourTableName

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a table is Sybase with a date field. &nbsp; I want to write a SQL query where I select all records where this Date Field is &gt;= first day of the current month, so in this case, 01-NOV-2005.<br />
<br />
Any ideas how I can accomplish this in SQL in Sybase. &nbsp; My date field has a time stamp as well.<br />
<br />
Thanks.
</div>
</div>


Hi,

I have a table is Sybase with a date field.   I want to write a SQL query where I select all records where this Date Field is >= first day of the current month, so in this case, 01-NOV-2005.

Any ideas how I can accomplish this in SQL in Sybase.   My date field has a time stamp as well.

Thanks.

First day of current month in Sybase

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.