Very simple SQL statement

[avgoustinosc]

Hi guys,

I have this select statement
"select date from dimtime"

I would like to display the date into format dd-mm-yyyy
How i can do that.
( I know that is too simple but in oracle database was select to_char(vdate,'dd-mm-yyyy') from dimtime. I do not know in sql)

[Bananafish]

CONVERT(char(10), @MyDateTime, 105)

[jmcilhinney]

A date is a date is a date. You use SQL code to retrieve date values from your database. Date values have no format. They just are. It is only when you want to display a date that it has to be converted to a string and then format becomes an issue. So, what I'm saying is just use your SQL to get your dates from Oracle without any thought of format. When you want to display them in a control on a form, then you need to think about format and it depends what control they're being displayed in as to how to go about it.

[avgoustinosc]

Thanks bananafish.