> > > 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.
Yes, but IMO it's not a very good idea to mix different language concepts, Harbour is rooted in Clipper, not SQL. > 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. Thanks, the concept is absolutely good, we need something similar, but with a more natural syntax. Brgds, Viktor
_______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
