Hi,

I am a preety newbie to SQL and was wondering how to get the date from the SQL to show up as Format(Date, "dd/mm/yyyy").

TIA.

Rohit

It depends on your DBMS. For Oracle, it is TO_CHAR( date, 'DD/MM/YYYY' )

Thanks a lot sir,

My problem was to get this value somehow.

Thanks a lot for your help.

rohit

if it is SQL Server you can use Convert function to convert the date into any format for ex: Select Convert(Varchar(10), GetDate() ,101)
will give you the date in mm/dd/yyyy format.
it depends upon the No you provide in the convert function, 101 stands for "mm/dd/yyyy" format

Balaji