sql - Get start and end date of current week in Sybase -

sql - Get start and end date of current week in Sybase -

i trying start , end dates of current week table in sybase ase database, , homecoming dates variables can add together insert call.

ideally, function can work based on getdate() function. have tried other methods & looked @ other answers, few catered towards sybase syntax. help appreciated!

you can utilize next combinations of datepart , dateadd find first , lastly days of week. may not efficient way it, i'm not much of sql dev, work. default setting has weeks starting on sunday , ending on saturday.

declare @dw_number smallint, @to_first_dw smallint, @to_last_dw smallint, @wk_begin_date datetime, @wk_end_date datetime, select @dw_number = datepart(dw,getdate()) //get day of week number select @to_first_dw = (@dw_number -1) * -1, //get number of days subtract week start @to_last_dw = 7 - @dw_number //get number of days add together week end select @wk_begin_date = dateadd(dd,@to_first_dw,getdate()), @wk_end_date = dateadd(dd,@to_last_dw,getdate()) select @wk_begin_date, @wk_end_date

sql sybase sybase-ase getdate