11 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
27 #Get the database handle
28 my $dbh = C4::Context->dbh;
30 #Query the database to get the dateformat
31 my $sth = $dbh->prepare("SELECT value FROM systempreferences WHERE variable='dateformat'");
35 my ($dateformat) = $sth->fetchrow;
40 sub display_date_format
42 my $dateformat = get_date_format();
44 if ( $dateformat eq "us" )
48 elsif ( $dateformat eq "metric" )
52 elsif ( $dateformat eq "iso" )
58 return "Invalid date format: $dateformat. Please change in system preferences";
68 my $dateformat = get_date_format();
70 if ( $dateformat eq "us" )
72 Date_Init("DateFormat=US");
73 $olddate = ParseDate($olddate);
74 $newdate = UnixDate($olddate,'%m/%d/%Y');
76 elsif ( $dateformat eq "metric" )
78 Date_Init("DateFormat=metric");
79 $olddate = ParseDate($olddate);
80 $newdate = UnixDate($olddate,'%d/%m/%Y');
82 elsif ( $dateformat eq "iso" )
84 Date_Init("DateFormat=iso");
85 $olddate = ParseDate($olddate);
86 $newdate = UnixDate($olddate,'%Y-%m-%d');
90 return "Invalid date format: $dateformat. Please change in system preferences";
94 sub format_date_in_iso
99 my $dateformat = get_date_format();
101 if ( $dateformat eq "us" )
103 Date_Init("DateFormat=US");
104 $olddate = ParseDate($olddate);
106 elsif ( $dateformat eq "metric" )
108 Date_Init("DateFormat=metric");
109 $olddate = ParseDate($olddate);
111 elsif ( $dateformat eq "iso" )
113 Date_Init("DateFormat=iso");
114 $olddate = ParseDate($olddate);
121 $newdate = UnixDate($olddate, '%Y-%m-%d');