hi all..

in my database, i have created date with format "15 June 2008"

how do i output it so i only take 15.. is it possible?

thanks

What database?

sql server 2000...

the format for the database is Varchar and not Date

Dim myDate As String = Trim(ddlStartDay.SelectedItem.Value) & " " & Trim(ddlStartMonth.SelectedItem.Value) & " " & Trim(ddlStartYear.SelectedItem.Value)

so in my database it will appear like '15 June 2008' and so on when retrieve it.
thanks

Select DatePart(dd, Cast('15 June 2008' as varChar))

It's much simpler when you store dates as dates not strings.

since i have 3 dropdownlist boxes... it is much easier for user to select dd/month/year rather than typing it..


what if 15 June 2008 not specific?

Select DatePart(dd, Cast('unknown value' as varChar))

Select DatePart(dd, Cast(ColumnName as varChar))

since i have 3 dropdownlist boxes... it is much easier for user to select dd/month/year rather than typing it

Assuming you concatenate the three values into a single string on insert, it's just as easy to convert to a date at the same time.
AND if your column is already a date type the conversion should be done automatically by the server on inserting.