471,893 Members | 1,473 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 3167
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
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.