I have a passthrough query which will not generate what I want, i.e. using
manifest_date, initial text 'Jan 1, 2012 09:33AM', and returns 'Jan 1, 2012' also text.
I want '01/01/2012' (text), MM and DD are always 2 digits.
Is the only way to do this conversion is to parse the date by m, d and y and then build the string date expected? Maybe I have to convert the long date to an actual date before the conversion???
Thank you in advance for any responses.
PHP:
UPDATE
dbo.tdw
SET
manifest_date = CONVERT(varchar(11),[manifest_date],101)
WHERE report_state='IL' AND
report_year=2012 AND
report_month=1;
manifest_date, initial text 'Jan 1, 2012 09:33AM', and returns 'Jan 1, 2012' also text.
I want '01/01/2012' (text), MM and DD are always 2 digits.
Is the only way to do this conversion is to parse the date by m, d and y and then build the string date expected? Maybe I have to convert the long date to an actual date before the conversion???
Thank you in advance for any responses.