Member Avatar for carrzkiss
carrzkiss 0 The Exchange of Knowledge!

Hello All;
I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database.
This is the code that I am using to generate the Google Sitemap with, however, there is code here that does not translate over to ACCESS Database.

SELECT imageid, imagetitle, MedUpdate as DefaultTime, convert(varchar(11),MedUpdate,121) as UModDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedUpdate, 113), 114) AS UMilTime, convert(varchar(11),MedDate,121) as JDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedDate, 113), 114) AS JTime FROM Images GROUP BY imageid, MedUpdate, MedDate, imagetitle order by imageid

Could someone please convert this over to a working ACCESS Query please?
Thanks.
Carrzkiss

  • 1 Contributor
  • 0 Replies
  • 139 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.