On Tue, Feb 10, 2009 at 7:02 PM, Viktor Szakáts <[email protected]> wrote:

> Nice, but could we avoid this strange syntax t"<text>" ?
> I find it rather strange in Harbour.

I find t"xyz" coherent with SQL where dates and times are simply literals.

Some examples are:

DATE'1999-12-25'
TIME'08:23:16'
TIME'14:23:16.5'
TIMESTAMP'1999-12-25 08:23:16'

select * from period where date = DATE '1999-12-25'

Datetime Literals:

|--+-+-DATE--'YYYY-MM-DD'-------+-----------------------+-------|
   | '-'alternative_date_value'-'                       |
   +-+---TIME--+-'HH:MM:SS'----------+---+--------------+
   | |         '-'HH:MM:SS.fraction'-'   |              |
   | '-'alternative_time_value'----------'              |
   '-+-TIMESTAMP--'YYYY-MM-DD--+-HH:MM:SS'----------+-+-'
     |                         '-HH:MM:SS.fraction'-' |
     '-'alternative_timestamp_value'------------------'

Not a request, just an example.

best regards,
Lorenzo
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour

Reply via email to