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 Date_Init("DateFormat=US");
72 $olddate = ParseDate($olddate);
73 $newdate = UnixDate($olddate,'%m/%d/%Y');
75 elsif ( $dateformat eq "metric" )
77 Date_Init("DateFormat=metric");
78 $olddate = ParseDate($olddate);
79 $newdate = UnixDate($olddate,'%d/%m/%Y');
81 elsif ( $dateformat eq "iso" )
83 Date_Init("DateFormat=iso");
84 $olddate = ParseDate($olddate);
85 $newdate = UnixDate($olddate,'%Y-%m-%d');
89 return "Invalid date format: $dateformat. Please change in system preferences";