11 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
26 #Get the database handle
27 my $dbh = C4::Context->dbh;
29 #Query the database to get the dateformat
30 my $sth = $dbh->prepare("SELECT value FROM systempreferences WHERE variable='dateformat'");
34 my ($dateformat) = $sth->fetchrow;
39 sub display_date_format
41 my $dateformat = get_date_format();
43 if ( $dateformat eq "us" )
47 elsif ( $dateformat eq "metric" )
51 elsif ( $dateformat eq "iso" )
57 return "Invalid date format: $dateformat. Please change in system preferences";
67 my $dateformat = get_date_format();
69 if ( $dateformat eq "us" )
71 $olddate = ParseDate($olddate);
72 $newdate = UnixDate($olddate,'%m/%d/%Y');
74 elsif ( $dateformat eq "metric" )
76 $olddate = ParseDate($olddate);
77 $newdate = UnixDate($olddate,'%d/%m/%Y');
79 elsif ( $dateformat eq "iso" )
81 $olddate = ParseDate($olddate);
82 $newdate = UnixDate($olddate,'%Y-%m-%d');
86 return "Invalid date format: $dateformat. Please change in system preferences";