Re: Date field in sql builder

Article View: borland.public.vdbase.data.sql

Article #55

Back to borland.public.vdbase.data.sql Previous Next

#55

From: Bowen Moursund (TeamB)
Date: Wed, 03 Mar 1999 00:00

14 lines
946 bytes

>Writing something simple like the following does not work in VdB 7.01 SQL
>Designer:
>select * from invoice where order_date > {01/01/1995}

You must supply a literal date string in this context, e.g.:

 select * from invoice where order_date > '01/01/1995'
__
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try these help resources:
http://www.dejanews.com/home_ps.shtml
http://forumsearch.inprise.com:88/

Technical Details

Message-ID: <7bk60a$2ii13@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7bk1bs$2i77@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,9c0ce2ccf9b5c6e5
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund (TeamB)" <bowenSEND_ME_NO_SPICED_HAM@nerds.com>
Subject: Re: Date field in sql builder
Date: 1999/03/03
Message-ID: <7bk60a$2ii13@forums.borland.com>
X-Deja-AN: 450882418
References: <7bk1bs$2i77@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message