Question related to split the whole string?

Is this ASP or ASP.Net?

How did u get the date? Is it today's date?

You could just use the formatting options to return just the date part
otherwise use the Split method and take out the value from subscript 0

this is ASP
I get date from stored Procedure, and it may be any date
I don't want to change the return format of stored Procedure
how do i use the formatting option please give example
Thank you

ASP

get current date, use DATE() so this returns 6/5/2007
get current time, use TIME() so this returns 11:46:38
get current date/time, use NOW()

in ASP u could also try using FormatDateTime
eg FormatDateTime('6/5/2007 11:46:38',2)
the 2nd parameter 2 means to return the short date format i.e. 6/5/2007

How to use Split
Dim sStr

sStr = Split('6/5/2007 11:46:38 AM',' ')
Response.Write sStr(0) 'returns 6/5/207

Ok, just saw your reply. I was about to post ASP.net version but wont bother now.

Ok, if stored procedure returning string, see if it works in FormatDateTime or try Split

It works
Thanks for your cooperation
But available format does not contain the am pm format
so for this need to write funtion?
can we do addition or subtraction between time variable(dim t)?

sorry, can u tell me what the exact output you want?
do u want

'6/5/2007 AM

manohar.patil, did you get your question solved?

If you did then please close this question and distribute the points. If you found the solution on your own, we would be very happy if you could explain it here for the sake other users having the same problem.

If you didn't get a solution to your problem, please leave a comment here to let the experts know that you're still looking for an answer.

Thanks,
The Quomon Admin Team

i think this can help you...

response.write(FormatDateTime(date(),vbgeneraldate)) /// for date 9/27/2007
response.write(FormatDateTime(now(),vbshorttime)) /// for time 02:50 AM