On Fri, 12 Sep 2008 11:19:41 -0700 (PDT), you wrote:
>I am new to SQLite
Since 51 weeks, to be exact ;)
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thank a ton Dennis.
I will try with the view then,
JP
- Original Message
From: Dennis Cote <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Friday, September 12, 2008 11:38:46 AM
Subject: Re: [sqlite] Convert the MAC address
Joanne Pham wrote:
>
> Can we convert these sql statement to function/store procedure so we can pass
> in the number and the return value back the character format.
> For example : ConvertMAC(29672054730752 ) and the return value back :
> 00:30:48:90:FC:1A
No, you can't create user defined
) and the return value back :
00:30:48:90:FC:1A
Thansk,
JP
- Original Message
From: Dennis Cote <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Friday, September 12, 2008 11:12:32 AM
Subject: Re: [sqlite] Convert the MAC address
Joanne Pham wrote:
> Sorry! the conversion is correct but it is in reverse order.
> The select statement return :
> 1A:FC:90:48:30:00
>
> and I checked the MAC Address:
>
> 00:30:48:90:fc:1a
> How to change it to correct order or may be the number 29672054730752 needs
> to be reverse.
>
- Original Message
From: Joanne Pham <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Friday, September 12, 2008 10:58:31 AM
Subject: Re: [sqlite] Convert the MAC address from integer to characters.
Thanks a lto Dennis!
But I g
is not correct.
Thanks,
JP
- Original Message
From: Dennis Cote <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Friday, September 12, 2008 10:12:37 AM
Subject: Re: [sqlite] Convert the MAC address from integer to characters.
Joann
Joanne Pham wrote:
> Thanks a lot for quick respond.
> I would like to have the format as : 00:15:C5:F1:1D:45
> Please help me how to convert this number 224577687400448 to
> this format 00:15:C5:F1:1D:45
This should do the trick. It's not pretty in SQL, and it might make more
sense to do it
eneral Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Friday, September 12, 2008 9:22:15 AM
Subject: Re: [sqlite] Convert the MAC address from integer to characters.
Joanne Pham wrote:
> I have this MAC Address as integer 224577687400448. Is there any
> buildin function in
Joanne Pham wrote:
> I have this MAC Address as integer 224577687400448. Is there any
> buildin function in SQLite to convert this MAC Address from integer
> to character format (IP Address format) as
> ...
No, there is not, but you can do it using a simple (well maybe not so
simple) expression
On Fri, Sep 12, 2008 at 09:11:02AM -0700, Joanne Pham scratched on the wall:
> Hi All,
> I have this MAC Address as integer 224577687400448. Is there any
> buildin function in SQLite to convert this MAC Address from integer
> to character format?(IP Address format) as?...
ARP?
MAC
Hi All,
I have this MAC Address as integer 224577687400448. Is there any buildin
function in SQLite to convert this MAC Address from integer to character
format (IP Address format) as ...
Thanks,
JP
___
sqlite-users mailing list
12 matches
Mail list logo