MS SQL GETDATE() not working in SQL command

Question

I am trying to update a record in my MS SQL database but cannot seem to get the GETDATE() function to work.

Will somebody look at the code below and tell me were am going wrong?

BEGIN
    update Bookings
  set TotalBookings = TotalBookings+1
  set LastBooked = GETDATE()
  where PropertyId='1007' 
END

You need to look at how to write SQL: UPDATE Statement properly!! — huMpty duMpty
– huMpty duMpty, Commented Apr 9, 2014 at 14:08

Habib · Accepted Answer · 2014-04-09 14:05:16Z

4

Your syntax is wrong it should be:

BEGIN
  update Bookings
  set TotalBookings = TotalBookings+1 ,
      LastBooked = GETDATE()
  where PropertyId='1007' 
END

You are using set multiple times, instead use set once and separate your columns with comma.

answered Apr 9, 2014 at 14:05

Habib

224k30 gold badges420 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1