Dennis Any ideas on the original question, about why the query fails when time format is set to HH:MM AP?
David Blocker ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 10:25 AM Subject: RE: Time format/Sequence challenge? > The rsyntax SET TIME point to the docs for the time data type. > > I have submitted the boo-boo to RDCC. > > Her is the correct syntax: > > SET TIME FOR HH:MM AP > SET TIME SEQ HHMM > > No quotes are needed as the interpreter is smart enough to know that the > TIME FOR setting may need a space. > > Now you can enter time as follows: > 11:45PM will be displayed as 11:45 PM > 1145PM will be displayed as 11:45 PM > 1145 will be displayed as 11:45 AM > 11PM will be displayed as 11:00 PM > 11AM will be displayed as 11:00 AM > 11 will be displayed as 11:00 AM > 1356 will be displayed as 1:56 PM > > you could also do: > SET TIME FOR HHMM AP > SET TIME SEQ HHMM > or > SET TIME FOR HHMMAP > SET TIME SEQ HHMM > > Hope this helps. > > --Dennis McGrath > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Nicky Avery > Sent: Saturday, November 30, 2002 3:22 AM > To: [EMAIL PROTECTED] > Subject: Re: Time format/Sequence challenge? > > > Claudine Robbins wrote: > > >Well, it doesn't work anyway. I tried the SET TIME HH:MM AP and it > >gives an "invalid command" error, > > > > Claudine, > > SET TIME is insufficient. It's necessary to specify the SEQ and FOR > separately and, I believe, to use AP, put the setting param in quotes > > RBHelp: "If the format contains spaces or commas, enclose the format in > quotes." > > > e.g: > > SET TIME SEQ 'HHMM AP' > > but using the above means that time has also to be entered in quotes > with a following AM or PM for correct results - a 24-hour clock > (military time) is much simpler. > > SET TIME FOR 'HH:MM AP' > > > David, > > Would the quotes make your code work in the desired way? > > Nicky > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
