Hi

I hav an application that record printing information. I am wanting to import the .log file that it creats into a sql db so that I can use RS ro create reports for our users. I have crerated a dts package to do the import - it all works fine untill I query the db - the date is in the format mm/dd/yyyy in the log file and therfore also in my sql db. The problem is that some of the date formats when quering show up as mm/dd/yyyy and the some of them appear as dd/mm/yyyy.

Is there a way to force the query to convert the date type to dd/mm/yyyy (i have used convert(varchar(10)date, 103) as Date) but this does not work. Also could there be a better way using a SP. I am new the DBA so please bear with me and thank you in advance

Greg

Your syntax is not correct using the CONVERT function.
Try... CONVERT(varchar(10), GETDATE(), 103).

Adam Gossage
Lake Wylie, SC, USA