Regarding Date DataType

[mansi sharma]

I want to ask that date is enter in the format--
MM / DD / YYYY

& result is retrived in which format?????

I want to display the date in the format as May 03,2008.
Suggestions are welcome....

[ck9663]

I want to ask that date is enter in the format--
MM / DD / YYYY

& result is retrived in which format?????

I want to display the date in the format as May 03,2008.
Suggestions are welcome....

Depends on your variable data type. In any case just use CONVERT

-- CK

[debasisdas]

You can format the output in any format you want as per your requirments.