Results 1 to 4 of 4

Thread: Default a Date column to Date of INSERTION (MySQL)

  1. Nov 4th, 2005, 01:12 AM #1
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747

    Default a Date column to Date of INSERTION (MySQL)

    How? I can only see Timestamp, which updates on update.
    Reply With Quote Reply With Quote
  2. Nov 7th, 2005, 02:02 AM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Default a Date column to Date of INSERTION (MySQL)

    Couldn't you set what would be the default value?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Nov 7th, 2005, 07:43 PM #3
    SkiNLaB
    SkiNLaB is offline

    Thread Starter
    Fanatic Member SkiNLaB's Avatar
    Join Date
    Jan 2002
    Location
    Sydney, Australia
    Posts
    747

    Re: Default a Date column to Date of INSERTION (MySQL)

    Only to a real value, I can't set it to a function it seems, ideally NOW()
    Reply With Quote Reply With Quote
  4. Nov 7th, 2005, 07:50 PM #4
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Default a Date column to Date of INSERTION (MySQL)

    I am not sure but have you tried GetDate? Or perhaps Date?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width