Do you want to deal with it in the query (harder), or in the code that
processes the query (easier)? Are you asking what Base64 is, or do you
know already and would just like some help doing something useful with
it from within the SQL language?
Just in case you don't know already, the date fields in the text you
have given below are "BEU0tK BEHwQV BEHwQV", and you need to decode them
using Base64, where each letter represents 1 of 64 possible values (eg
our numbering system is Base10 and the digits are 0123456789, base64 is
the same but with all the numbers (10), all the lowercase letters (26),
all the uppercase letters (26), and another 2 characters ('+' and '/' I
think, but you'd need to check), giving you your 64 'digit'
combinations.
Once you have decoded these values you should have a number that
represents the number of seconds since midnight on Jan 1 1970 UTC.
The following URL is to a really cool page that allows you to convert
between all sorts of encoding methods:
http://www.paulschou.com/tools/xlate/
'man stat' should tell you about the 'struct stat' where all these
fields are.
HTH
James
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:bacula-users-
> [EMAIL PROTECTED] On Behalf Of Mark Nienberg
> Sent: Thursday, 11 May 2006 08:35
> To: bacula-users@lists.sourceforge.net
> Subject: [Bacula-users] Re: File attributes
>
> Mark Nienberg wrote:
> > I'd like to write an SQL query to extract some information from the
> > bacula catalog including file dates. I see from the bacula
developers
> > guide that the "File" table has a field named "LStat" that is
defined as
> > "File attributes in base64 encoding". I assume my file dates are in
> > there, but how do I deal with the base64 bit?
> >
> > A typical entry looks like this:
> > P0A HL4KO IHk B A A A BdD BAA Y BEU0tK BEHwQV BEHwQV A A C
> >
> > Thanks,
> > Mark
>
> Anyone?
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,
security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
>
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
