Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Command for delete parts of data?

Quote Reply
Command for delete parts of data?
Hi somehow I managed to add time for my data...
I have date created on my database with data like:
11/11/1987 0:00:
2/2/1998 0:00:0
As you can see this is just varchar column with size 15.

I Also have some data, that does not have date info at all.

What I want is to display just date, and no time (No time info available) and the data, that does not have date available, I want it be blank not 00-00-0000.(ie no data on column)

I tried setting column size to 10, but some info that has 1 digit months and 1 digit dates still displays 0 at the end of the date like:
1/1/1995 0
???
Is there a command that I could set, that would remove 0:00 at the end?


Last edited by:

Suomi: Dec 10, 2001, 10:42 AM
Subject Author Views Date
Thread Command for delete parts of data? Suomi 3389 Dec 10, 2001, 10:41 AM
Thread Re: [Suomi] Command for delete parts of data?
604 3301 Dec 10, 2001, 11:30 AM
Post Re: [TheStone] Command for delete parts of data?
Suomi 3256 Dec 13, 2001, 12:36 PM
Thread Re: [TheStone] Command for delete parts of data?
Suomi 3282 Feb 11, 2002, 11:45 AM
Thread Re: [Suomi] Command for delete parts of data?
604 3243 Feb 11, 2002, 12:08 PM
Thread Re: [TheStone] Command for delete parts of data?
Suomi 3282 Feb 11, 2002, 12:19 PM
Thread Re: [Suomi] Command for delete parts of data?
604 3287 Feb 11, 2002, 12:31 PM
Thread Re: [TheStone] Command for delete parts of data?
Suomi 3225 Feb 11, 2002, 12:55 PM
Post Re: [Suomi] Command for delete parts of data?
604 3253 Feb 11, 2002, 1:48 PM
Post Re: [Suomi] Command for delete parts of data?
jean 3225 Feb 11, 2002, 1:49 PM