How are people representing subsecond date/time values with MySQL? In Sybase, the datetime data type supports subsecond values with a resolution of 1/300th of a second (go figure). PostgreSQL does microseconds with its time (4 bytes) and timestamp (8 bytes) data types.
More generally, JDBC provides java.sql.Timestamp which can represent nanoseconds (though I haven't found a database that supports nanoseconds yet). I would prefer to be able to use a single column to represent date + time with some reasonable subsecond granularity. I could use bigint since Java uses 64-bit values to represent timestamps, but then I lose any useful date manipulation facilities in SQL. Thanks, ~chuck **************************************************************************** IMPORTANT NOTICES: **************************************************************************** This message is intended only for the addressee. Please notify the sender by email if you are not the intended recipient. If you are not the intended recipient, you may not copy, disclose, or distribute this message or its content to any other person and any such actions may be unlawful. Electronic mail sent through the Internet is not secure. WR Hambrecht + Co (WRH+Co) does not accept time sensitive, action-oriented messages or transaction orders, including orders to purchase or sell securities, via email. WRH+Co reserves the right to monitor and review the content of all messages sent to or from this email address. Messages sent to or from this email address may be stored on the WRH+Co email system. **************************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
