date sql 2008 to datetime sql 2005

Question

Im having a problem with sql 2005, it doesn't recognise 'date' which I already know but how would I use date time just to get the date in the following statement to work in sql2005. I have tried datetime and it doesnt work as I dont need datetime just date:

(cast(getdate()as date)as varchar(50))-This part is where the problem is happening if I use datetime

set @ScheduleTime =(cast(cast(getdate()as date)as varchar(50))+' '+convert(varchar(8),@ScheduleTime,108))

Answer 1

Try the below:

Select Replace(CONVERT(Varchar(10),Getdate(),102),'.','-')

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

SELECT CONVERT(VARCHAR(10),GETDATE(),121)

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 3

Try the same in your code:

set @ScheduleTime =(CONVERT(VARCHAR(10),GETDATE(),121)+' '+convert(varchar(8),@ScheduleTime,108))

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

How would I incorporate that into my statement ?

Answer 5

Hi,

In SQL server 2005 you don't have any function to do so but you can take only date part as below.

SELECT CONVERT(VARCHAR(11),GETDATE(),105)

---

sarat chandra sahoo