possible to sort of date portion of a date/time field

LabKey Support Forum (Inactive)
possible to sort of date portion of a date/time field Ben Bimber  2010-10-06 17:03
Status: Closed
 
what's the most efficient way in labkey SQL to grab the date portion of a date/time field? seems like I need to grab the year(), month() and day(), concatenate, then make a date out of this string? is there some function that does it more directly?