469,106 Members | 2,250 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

uk sql date

My query:

SELECT DateValue([Date/time call received]) AS [Date], TimeValue([Date/time
call received]) AS [Time], [T-cards].[Call type], [T-cards].[Sales outcome],
[T-cards].Postcode, [T-cards].[Customer name/contact]
FROM [T-cards]
WHERE (((DateValue([Date/time call received])) Between [Start Date] And [End
Date]) AND ((TimeValue([Date/time call received]))>TimeValue("08:00") Or
(TimeValue([Date/time call received]))<TimeValue("17:00")) AND
(([T-cards].[Call type])="Job") AND (([T-cards].[Sales outcome])="Booked"))
ORDER BY DateValue([Date/time call received]);
is hoping to return dates in uk format (entries between 8am and 5 pm), but
only works if you input the us date format mm/dd/yy. Can anyone help with
the uk date format..?

Thanks,
Lap
Jul 20 '05 #1
1 3106
Hi

Date formats can be effected by several things, including the language
settings, use of SET DATEFORMAT etc. You may want to check out sp_configure,
SET etc in books online.

If you want to specify a specific date/time format in an SQL statement check
out the CONVERT function

John
"Lapchien" <cc****@nospamplease.eclipse.co.uk> wrote in message
news:10***************@ananke.eclipse.net.uk...
My query:

SELECT DateValue([Date/time call received]) AS [Date], TimeValue([Date/time call received]) AS [Time], [T-cards].[Call type], [T-cards].[Sales outcome], [T-cards].Postcode, [T-cards].[Customer name/contact]
FROM [T-cards]
WHERE (((DateValue([Date/time call received])) Between [Start Date] And [End Date]) AND ((TimeValue([Date/time call received]))>TimeValue("08:00") Or
(TimeValue([Date/time call received]))<TimeValue("17:00")) AND
(([T-cards].[Call type])="Job") AND (([T-cards].[Sales outcome])="Booked")) ORDER BY DateValue([Date/time call received]);
is hoping to return dates in uk format (entries between 8am and 5 pm), but
only works if you input the us date format mm/dd/yy. Can anyone help with
the uk date format..?

Thanks,
Lap

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by androtech | last post: by
4 posts views Thread by Richard Hollenbeck | last post: by
2 posts views Thread by Tjerk | last post: by
9 posts views Thread by Thomas R. Hummel | last post: by
30 posts views Thread by Dr John Stockton | last post: by
1 post views Thread by Liz Malcolm | last post: by
12 posts views Thread by Assimalyst | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.