Toad World® Forums

Default Value only a textfield?


#1

Hello,

how can I set a default value for an attribute with the datatype timestamp?

In the attribute view is a field which is called Default. But this is only a textfield. I would expect an dropdownfield, where I can choose for example ‘current time’?

Regards

Balian


#2

Hi,

I do not know what your target database is, but in MySQL you can define the default value for timestamp as NOW() or its synonym. See attached screenshot. In fact, you can define default value your own way.

BTW as far as I know, current time won’t work for timestamp as a default value.

Regards,

Vaclav