DateTime format

[Assaf82]

Hello I need to view the data in the datagridview from the table through an sql statment but i don't want the date will be like: "1983-01-01 00:00:00" i want just show:"1983-01-01" or show:"01-01-1983" Thanks in advance

Assaf

[soni uma]

You can done it by convert(varchar,getdate(),101) umesh

[squattyarun]

there are two ways to achieve it either from sql server by using Convert(varchar(30),getdate(),101) it will convert your date to desired format. other one is use Format(XXX, "dd MMMM, yyyy") function in .NET ...

Arun Singh Noida.

[Andy_L_J]

Set: DataGridView.Columns(n).DefaultCellStyle.Format = "dd/MM/yyyy"

The Fanatical All Black Supporter - Kea Kaha