hi every one,
can any one help me on datetime conversion prob which might be gone thru by others earlier...
iam using SQL SERVER as db and iam getting the date in format dd/mm/yyyy.but my db uses the date format as mm/dd/yyyy.
i need to return the date values in same format as i get it (i.e dd/mm/yyyy).how should i get out of this prob..
here is sample ex prob which iam going thru..
my table: tdate
create table tdate ( cdate datetime,hcode int )