Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

datetime field automatically defaults to 12:00 AM when null

2 posts in DataWindow Last posting was on 2008-04-24 20:47:26.0Z
TonyMIS Posted on 2008-04-18 17:04:49.0Z
From: TonyMIS <aesteves@bostonfinancial.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: datetime field automatically defaults to 12:00 AM when null
Date: Fri, 18 Apr 2008 10:04:49 -0700 (PDT)
Organization: http://groups.google.com
Lines: 6
Message-ID: <d6e0ec61-ce91-4ba8-9e6f-aef5e8d5340b@d1g2000hsg.googlegroups.com>
NNTP-Posting-Host: 209.0.112.9
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1208538290 12321 127.0.0.1 (18 Apr 2008 17:04:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 18 Apr 2008 17:04:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d1g2000hsg.googlegroups.com; posting-host=209.0.112.9; posting-account=XF6ckgoAAACs7hQvjds3XT2_H3YZR6k7
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.gamma.ru!Gamma.RU!postnews.google.com!d1g2000hsg.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86668
Article PK: 415927

Hello
PB9 MS SQL Server 8.00. I have a datetime field (in a dw) that I have
formatted as "h:mm AM/PM."
When a record has no data in that field I want nothing (blank) to
print. Instead, it prints '12:00 AM'.
How can I make it print blank?


Millard F. Brown III Posted on 2008-04-24 20:47:26.0Z
From: "Millard F. Brown III" <millard.brown@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <d6e0ec61-ce91-4ba8-9e6f-aef5e8d5340b@d1g2000hsg.googlegroups.com>
Subject: Re: datetime field automatically defaults to 12:00 AM when null
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4810f1de$1@forums-1-dub>
Date: 24 Apr 2008 13:47:26 -0700
X-Trace: forums-1-dub 1209070046 10.22.241.152 (24 Apr 2008 13:47:26 -0700)
X-Original-Trace: 24 Apr 2008 13:47:26 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86712
Article PK: 415972

Try setting the expression for the column format to

if(isnull(<column name>),' ','h:mm AM/PM')

note that the ' ' in the expression has a space in it. Just '' won't work.

--
Regards,
Millard [TeamSybase]

"TonyMIS" <aesteves@bostonfinancial.com> wrote in message
news:d6e0ec61-ce91-4ba8-9e6f-aef5e8d5340b@d1g2000hsg.googlegroups.com...
> Hello
> PB9 MS SQL Server 8.00. I have a datetime field (in a dw) that I have
> formatted as "h:mm AM/PM."
> When a record has no data in that field I want nothing (blank) to
> print. Instead, it prints '12:00 AM'.
> How can I make it print blank?