How can I get the current session id?

[batmanneverdie]

Does there have some SQL statement like show session or select current_session() to tell user the current session info even just only session id?