Hi,   I currenty have a timestamp field converted to a timestamp via cast(a.timefield as timestamp).   I need to be able to extract the time from the timestamp and then use this in the where clause to filter on results with time between 20:30:00 and 08:00:00.   Any assistance appreciated.   many thanks. ... View more