Splitting Columns

[SirGally]

I have a Date/time column in the format 'DD\MM\YYY HH:MM:SS'

I need to query the time and not the date, but there on the same column.

so for example:

Print_Date

30/11/06 15:00:59
29/11/06 12:15:13
23/11/06 06:55:44

I need a query that will give all items printed before 18:00:00 EVERYDAY!

Ive tried CREATE VIEW coupled with Right(Print_Date,12)but kept getting errors!!

Any ideas??

 

[erics55]

Hi
Try substring([Print_Date], 10, 10)

This will give you a time value as a string

It might be better splitting the value into sections so format it

HHMMSS and casting this as a numeric value then you can say

if time < 180000 then true

Thanks

 

[gmmastros]

Select * 
From   Table
Where  [!]DatePart(Hour, [/!]Print_Date[!]) <= 18[/!]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SirGally]

Thanks for the imput guys,

Used your method George, worked first time.

Thanks