Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

date conversion in mysql from access

dgowersdgowers Member Posts: 1
is there anyway to convert a date from access in format "ddmmyy" to a mysql format "yymmdd"??? Please email me if u have an answer to dgowers@uk.bnsmc.com

Comments

  • JonathanJonathan Member Posts: 2,914
    : is there anyway to convert a date from access in format "ddmmyy" to a
    : mysql format "yymmdd"??? Please email me if u have an answer to
    : dgowers@uk.bnsmc.com

    If the formats simply need to be changed around, you could do it by simple pattern matching. E.G. in Perl:-

    $date =~ s/(dd)(dd)(dd)/$3$2$1/;

    Jonathan


    ###
    # Example Of Perl 6 Syntax.
    push @will, my Power $button;
    my $hardware is Useless but Valuable;
    do ($nothing) while $i.work and print $stuff;
    push (@will, my Off $button) and die "with me";

Sign In or Register to comment.