Date in SQL
Posted on 2012-09-14
I have a filed that is data time in the database. I want this field to show in one column as date and different column as time.
right now it is showing
it should show like this 09/26/2011 8:00 Am
the field name is : Appointment.ActualDateTime
SELECT Appointment.Id, Staff.FirstName + ' ' + Staff.LastName AS Staff_Name, Appointment.ActualDateTime,
second part to this: when I input the parameter to run data from one date to another, I would like to insert the date only. so if I am looking for 08/01/2012 data, it should give me everything fpor that date, right now, it is trying to filter the date and hour. What I have been doing is inputting >=08/01/2012 and <08/02/2012 to get all appointments.