dateformat and i need space in database...

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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...

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts