Doubt in Date function

[Murali Dharan]

Hi,

Anyone help me in this problem.

I want to insert date time with microseconds... .

For example:

Iam inserting value to the field using NOW(), the values of the date time is inserted to the table but i need the microseconds also to be inserted to my table.

What shall i do in this case?

Is that any function available in Mysql for retreiving the datetime with microseconds?

[ScarletPimpernal]

It seems to be that MYSQL doesnot support the Fractional Value of Date till ... (till MYSQL 5.0).

If someone gives answer for this then it will be useful for me also..


Thanks,
Pimp

Hi,

Anyone help me in this problem.

I want to insert date time with microseconds... .

For example:

Iam inserting value to the field using NOW(), the values of the date time is inserted to the table but i need the microseconds also to be inserted to my table.

What shall i do in this case?

Is that any function available in Mysql for retreiving the datetime with microseconds?