TD 14 MVC

Database
Enthusiast

TD 14 MVC

Hi,

Is it possible to apply MVC on

1)timestamp(6)

2) INTEGER FORMAT '99:99:99'

Thank you.

3 REPLIES
Enthusiast

Re: TD 14 MVC

Xmm. introduced on 14.10 ?

Junior Contributor

Re: TD 14 MVC

MVC on TIME and TIMESTAMPS is new in 14.10 (before only NULLs can be compressed), but you can compress INT in any release. In your case it's probably one of the old fake time columns, just use integers without any formatting:

COMPRESS (0,120000,235959)
Enthusiast

Re: TD 14 MVC

Hi,

Thanks , i changed the mvc script to cast to integer.

This works , thank you for your time.