dateformat and i need space in database...

Posted by Sheeba under ASP.NET on 4/5/2011 | Points: 10 | Views : 953 | Status : [Member] | Replies : 1
Hi

My output like the following:

DETAILS
----------------------------------
01524-SEP-10 08.38.50.000000 AM
01520-JAN-11 03.24.21.000000 PM
01530-DEC-10 02.52.33.000000 PM
01603-MAR-11 03.17.16.000000 AM
01617-FEB-11 05.49.10.000000 AM
01603-MAR-11 03.22.45.000000 AM
01603-MAR-11 03.34.25.000000 AM
01603-MAR-11 03.42.20.000000 AM
01603-MAR-11 03.43.54.000000 AM
01603-MAR-11 03.38.59.000000 AM
01619-JAN-11 01.28.53.000000 PM

But i want like this:

DETAILS
*******
015 24-SEP-10 only...one space need b/w 015 and date

Help me plz....

Thanks...




Responses

Posted by: Prabhakar on: 4/6/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
hi sheeba

u do this in Insert time . . in aquery define space between space & date . .




Best Regard's
Prabhakar

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response