date conversion in mysql from access

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 [email protected]

Comments

  • : 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
    : [email protected]

    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.

Howdy, Stranger!

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

Categories

In this Discussion