Hi,
I use Ms sql server and I have a date field(datetime) and I use getdate() function to insert date into this field.like this:
2006/04/25 02:24:13
Now how can I format and output the field like this
apr, 14th , 6:30am
I need the code please

This is cut n paste code:

function customDate(varDate)
   if isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
      customDate = "Null"
   else
      customDate = MonthName(DatePart("m", varDate), True) & ", " & Day(DateValue(varDate)) & ", " & TimeValue(varDate) & ""
   end if
end function

dim dval
dVal = "2006/04/25 02:24:13"
response.write customDate(dVal)

Wind is your friend
Matt