Help for this page

Select Code to Download


  1. or download this
    select distinct cast(DATE as date) from myschema.mytable GROUP BY DATE
  2. or download this
    
create table foo (IDENTITY INT, LoginTime DATETIME);
...
--Select unique
SELECT distinct cast(LoginTime as date) FROM foo GROUP BY LoginTime;
  3. or download this
    #!/usr/bin/perl
use strict;
...
}

$dbh->disconnect;
  4. or download this
    [29-09-2019]
[30-09-2019]
  5. or download this
    $VAR1 = [
          [
...
          ],
          $VAR1->[0]
        ];
  6. or download this
    $sth->execute();

...
foreach my $row_ref (@all_rows) {
    print "$row_ref->[0]\n";
}