>is it possible (how?) to insert into 2 different fields (date) the following >values:
>09:30:00 (only a time value...) >14/07/07 (only year value, 14th of december 2007) Just store date and/or time as string: "20070714" or "070714", "093000". It is compact, you can sort them easily etc. You can store them also as Integer: 20070714, 93000, this will save space in database, as integers are stored in variable-length format (VarInt). ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------