Cutting time off of date

[chezealot9]

Hey Guys, when Im inserting a date into a label its attaching 1200AM to it, how can I get cut this part off? Im converting it with reader.getsqldatetime....

Thank you very much for any help!!

 

[Cenedra]

Get the short date...

 

[chezealot9]

Whats the best way to do that because its stored in the database as a shortdate?

 

[Cenedra]

reader.getsqldatetime is the problem - is there another method that extracts the data as just a date or a short date?

 

[cbokowski]

if you are using sql server you can use convert

ex

SELECT Convert(char(10),DtMyDate,101)
FROM MyTable

 

[chezealot9]

IS there any sort of convenient string function I can use to just chop off the time, because it'd be like _/_/_ 1200AM so I could drop it after the space in the vb code?

Thanks for your help guys!!

 

[cbokowski]

Have you used "FormatDateTime"

lblTest.text = FormatDateTime(now,DateFormat.ShortDate)

 

[chezealot9]

I haven't, would that work here?

 

[chezealot9]

I mean the main problem is that its a short date in sql but for some reason the asp conversion is tacking on the time.