Mailing List Archive


Back to the month index Back to the list index
Christopher Cavnor (ccavnor@sprynet.com)
Fri, 21 Nov 1997 12:37:20 -0800 

Message-ID: <3475F100.641A@sprynet.com>
Date: Fri, 21 Nov 1997 12:37:20 -0800
From: Christopher Cavnor <ccavnor@sprynet.com>
Subject: mystery pid file

I am trying to get the WIN32 version of mDQL (msql116c-w32) up and
running. I continue to get permission errors in msqladm when trying to
create a new database. I think that I have traced the problem to a
missing pid file. The setup utility seems to have missed this file. Does
anyone know what this file should be named?

ccavnor@sprynet.com
From kit@lim.com Fri Nov 21 15:51:24 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id PAA22068
        for <msql-list@services.bunyip.com>; Fri, 21 Nov 1997 15:51:23 -0500 (EST)
Received: from lim.com (lim-cisco.lim.com [207.170.66.226])
        by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id PAA05019
        for <msql-list@bunyip.com>; Fri, 21 Nov 1997 15:51:22 -0500 (EST)
Received: from limaus.lim.com (limaus.lim.com [207.170.66.36])
        by lim.com (8.8.7/8.8.7) with SMTP id OAA25396
        for <msql-list@bunyip.com>; Fri, 21 Nov 1997 14:52:53 -0600 (CST)
Received: from acrobat.limaus by limaus.lim.com (4.1/S2.1)
        id AA08544; Fri, 21 Nov 97 14:52:51 CST
Received: by acrobat.limaus (SMI-8.6/SMI-SVR4)
        id OAA12309; Fri, 21 Nov 1997 14:51:11 -0600
Date: Fri, 21 Nov 1997 14:51:11 -0600
From: kit@lim.com (Kit Lou)
Message-Id: <199711212051.OAA12309@acrobat.limaus>
To: msql-list@bunyip.com
Subject: date format
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Md5: tKpjUo0tHSEJq1XHHf9kZA==

Can someone enlighten me as to what the format for entering date for a
field defined with the date data type is in mSQL2?

I have tried various combinations to no avail and I cannot seem to find
documentation on the date format.

Thanks,

Kit H. Lou
LIM International, Inc.
Austin, TX, USA

email: kit@lim.com
From dchristenson@gsu.edu Fri Nov 21 20:45:17 1997
Received: from sphinx.Gsu.EDU (sphinx.Gsu.EDU [131.96.1.22])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id UAA02130
        for <msql-list@services.bunyip.com>; Fri, 21 Nov 1997 20:45:17 -0500 (EST)
Received: from gsu.edu (ts040004-port16.Gsu.EDU [131.96.150.64]) by sphinx.Gsu.EDU (8.8.7/8.7.3) with ESMTP id UAA05541; Fri, 21 Nov 1997 20:18:44 -0500 (EST)
Message-ID: <34763448.11CD1630@gsu.edu>
Date: Fri, 21 Nov 1997 20:24:24 -0500
From: "Daniel A. Christenson" <dchristenson@gsu.edu>
Organization: Georgia State University
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: kit@lim.com
CC: Multiple recipients of list <msql-list@services.bunyip.com>
Subject: Re: date format
References: <199711212051.OAA12309@acrobat.limaus>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

  The mSQL Date format is 'dd-mm-yyyy' as in

   insert into sampletable values ('Hello','05-Nov-1997')\g

Kit Lou wrote:

> Can someone enlighten me as to what the format for entering date for a
> field defined with the date data type is in mSQL2?
>
> I have tried various combinations to no avail and I cannot seem to find
> documentation on the date format.
>
> Thanks,
>
> Kit H. Lou
> LIM International, Inc.
> Austin, TX, USA
>
> email: kit@lim.com 

--
Daniel A. Christenson         University Educational Technology Services
Lab & Network Administration  Georgia State University
Office (404) 651-1031         Fax: (404) 651-3606
Email: dchristenson@gsu.edu   http://uets.gsu.edu/