57 users online (0 members and 57 guests)  


  Results 1 to 2 of 2

Related

  1. perl problem    Forum: CGI Perl Forum
    Replies: 2
  2. My Auction date problem    Forum: PHP Forum
    Replies: 1
  3. Perl dbi with mysql problem    Forum: CGI Perl Forum
    Replies: 1
  4. Use VB generated date in Perl??    Forum: CGI Perl Forum
    Replies: 3
  5. cgi script/perl problem    Forum: CGI Perl Forum
    Replies: 4
  1. #1
    SEA_Elvir's Avatar
    New User

    Status
    Offline
    Join Date
    Aug 2005
    Posts
    1

    Perl date problem in myqsl

    I have 3var to get date like this 2005-05-11(so I have var1=year-2005, var2=mounth-05, var3=day-11) and Im put this date to field1 in mysql,after I want to add 25 value to day and put new date in field2.... whan I add value 25 to var3(day) I get date 2005-05-36...So how I can tell that whan number come to 31 to go to other mounth and get date like 2005-06-05?????

    Pleas I need this as soon as posible! Thx anyway

  2. #2
    fireartist's Avatar
    New User

    Status
    Offline
    Join Date
    Sep 2005
    Posts
    3

    Re: Perl date problem in myqsl

    Use the mysql function DATE_ADD(). See the docs .

    Code:
    DATE_ADD( '2005-05-11', INTERVAL 25 DAY )



Tags for this Thread