List:General Discussion« Previous MessageNext Message »
From:Patricio A. Bruna Date:October 12 2007 2:09pm
Subject:Re: Trigger
View as plain text  
Mostly because use 2 field to represent the same data is a waste of storage i think.

----- "Martijn Tonies" <m.tonies@stripped> escribió:
> >The aplication which is writing to the database is sending the date
> in unix
> format.
> >I can't no change that, so i suposse using a triger will help.
> >
> >The application pass the 'xxxxxx.xx' value when is inserting to the
> table.
> 
> Righto. Well, what does this mean then:
> 
> >im converting the unixtime to "normal" time with from_unixtime.
> >So after i did the convertion i write the result to the table.
> >It works ok when i write to a varchar column, but not to a date
> column
> 
> Why not store the "unixtime" value and use an additional column to
> store
> an actual DATE value instead?
> 
> 
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
> Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
> http://lists.mysql.com/mysql?unsub=1

Thread
TriggerPatricio A. Bruna11 Oct
  • Re: TriggerMartijn Tonies12 Oct
    • Re: TriggerPatricio A. Bruna12 Oct
      • Re: TriggerMartijn Tonies12 Oct
        • Re: TriggerPatricio A. Bruna12 Oct
          • Re: TriggerMartijn Tonies12 Oct
            • Re: TriggerPatricio A. Bruna12 Oct
              • Re: TriggerMartijn Tonies12 Oct
Re: TriggerPatricio A. Bruna11 Oct