I want to set up two columns in a timeclock report for the punch in and punch out times, that only show the times formatted as hh:mm:ss AM/PM, and not show the date portion. I tried using CONVERT() to convert the data in TimeClock.TimeIn and TimeClock.TimeOut into data type 108, which i think should be hh:mm:ss, but it is still showing up as the full date and time when i generate the report.
am i doing something wrong? can this be displayed this way?
thanks, kevin
Kevin I'm just wondering why you would want to display it without a date. Logically wouldn't you want the date included as well to know exactly what dates someone worked. I believe it would be totally confusing to have times only with no way to associated a date.
Just wondering.
I already have a separate column to the left of the punchin and out columns that contains just the date - this is my first column and i use this to group total hours by day. the punch in and punch out times in column 2 and 3 are for the same day, what I want to do is just display those columns as the time of the day, without showing the date portion
kevin
"Elizabeth" wrote:
A DateTime value always includes a date. You're still converting to a DateTime Value - to get just the time, you have to use DATEPART
select top 10 TransactionNumber, CAST(DATEPART(hh, [Time]) as varchar) + ':'
Glenn, thanks for the tip. That almost does what I need, however it returns the time in military instead of AM/PM, and it doesn't format it the best - for example, 3:15:04 PM shows up as 15:15:4, and ideally i'd like to show it as 3:15:04 PM, or in the very least 15:15:04
any way that this can be done?
thanks, kevin
Have something to add? Share your thoughts — no account required.
Ask the community — no account required